# Massive Multilingual App
**URL:** https://community.glideapps.com/t/massive-multilingual-app/11268
**Category:** Ask for Help
**Created:** [June 22, 2020, 4:07pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268 "2020-06-22T16:07:06Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@ajchan](https://community.glideapps.com/u/ajchan)
#### Post date: [June 22, 2020, 4:07pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/1 "2020-06-22T16:07:06Z")
Hi Experts,
I have a massive (2M+ records) database I’ve built and been maintaining for close to 20 years for a popular website similar to imdb. I’m thinking of moving that to a glideapp. Here are the questions before I embark on this.
1. I see the following limitations for Google Sheets – _Up to 5 million cells for **spreadsheets** that are created in or converted to **Google Sheets**. 40,000 new **rows** at a time. **Maximum** number of columns of 18,278 columns._ Assuming I stay within these limits how performant will be the app – Of course these constrains will be adhered to - [No-Code App Builder: Create Custom, AI-Powered Apps | Glide](https://www.glideapps.com/pro#summary)
2. I want this to be duo lingual like the website. I have the transliteration for all 2M+ records between English and Unicode characters. Is there some kind of a global variable I can use to let users select/change their language of choice so that the app can look up the data from either appropriate columns or sheets with the language preferences
3. (Not directly related to glide) Are there any preferred solutions for MySQL → Google Sheets synchronization?
4. Any other preliminary considerations I should be thinking of right now ?
Thanks
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 22, 2020, 4:18pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/2 "2020-06-22T16:18:20Z")
> [@ajchan](#):
>
> Is there some kind of a global variable I can use to let users select/change their language of choice so that the app can look up the data from either appropriate columns or sheets with the language preferences
Create a user-specific choice in your user profiles sheet, and set the visibility of tabs based on it. Let’s say you can build a whole tab with English and it will only display when English is chosen, same goes for other languages.
> [@ajchan](#):
>
> Are there any preferred solutions for MySQL → Google Sheets synchronization?
I think you can start by reading this:
> **[How to Retrieve SQL Data Automatically Using Google Sheets Script | Actiondesk](https://www.actiondesk.io/blog/google-sheets-script-to-automatically-retrieve-sql-data)**
>
> Learn how to automatically retrieve data from your SQL database and import it into Google Sheets with a script that you can copy and paste right into Google App
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [June 22, 2020, 4:37pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/3 "2020-06-22T16:37:33Z")
@ajchan First to make sure that nothing is lost in translation, I am assuming that by “2M+ records” you mean:
- 2 million
- Records: table items or list items or rows
My immediate answer would be that the scale of your project exceeds Google Sheets and Glide.
If all data needs to be accessed by the app at all times or reside in a Google Sheets at all times, with 2 million records, you will achieve that neither with Google Sheets, nor with Glide (for the time being). You would have to wait until Glide apps work with other databases such as Big Query.
Also, I would avoid a technical setup where you might be able to make it work somehow, but that really would be a short-term fix.
That being said, this is just my knee-jerk answer and based on my current understanding so far of the limitations of Glide and Google Sheets.
---
### Author:  [@ajchan](https://community.glideapps.com/u/ajchan)
#### Post date: [June 22, 2020, 4:56pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/4 "2020-06-22T16:56:01Z")
Thanks @ThinhDinh – Since there will be several categories the users would want to search off of, ‘tabs’ won’t work. I need to have them as as inline lists. Where I’m confused is to depending on a value of the user profile, how do I select a separate sheet ? I presume I can use different inline lists based on different sheets and have the visibility set that way.
Thanks a lot @nathanaelb for the caution. Yes, 2 Million in total, largest table has about 150k rows, total rows across all tables will be 300k, each of the tables having anywhere from 5-20 columns. Maybe these numbers are lower than what you think ?
What would be a reasonable scale of the data that glide can handle ?
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [June 22, 2020, 5:26pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/5 "2020-06-22T17:26:01Z")
@ajchan
It is good we confirmed what we are talking about:
- 2 million data points or cells across all of your tablez (or worksheets)
- A total of approximately 300K rows across all worksheets in your spreadsheet (unique document associated to your app).
I still think you would be pushing it. I don’t think Glide can currently support than amount of data in one single app.
[Pricing & Limits per plan](https://www.glideapps.com/pricing)
---
### Author:  [@ajchan](https://community.glideapps.com/u/ajchan)
#### Post date: [June 22, 2020, 5:54pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/6 "2020-06-22T17:54:40Z")
That’s great to know. So, I presume 25000 rows of data is not per worksheet but combined rows across all worksheets. I assumed the former.
---
### Author:  [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [June 22, 2020, 7:18pm UTC](https://community.glideapps.com/t/massive-multilingual-app/11268/7 "2020-06-22T19:18:09Z")
> [@ajchan](#):
>
> Not directly related to glide) Are there any preferred solutions for MySQL → Google Sheets synchronization?
I don’t have any experience here, but this may be worth a look: [https://flex.io/](https://flex.io/)