White-Labeling Database

[Paw_of_Doody]

Would Google Sheets limit the apps production speed, if there’s a lot of data being input to the google sheets? If I find it is… What would you recommend as a next step for the database?

[Marc_Dillon]

What is “production speed”?

What is “a lot of data”?

[Paw_of_Doody]

By “production speed” I meant would there be any reason the app would be slowed from using Google Sheets as opposed to something else.

I don’t have numbers as far as a lot of data… But if I sell it to multiple people there could be any amount of data input.

[Marc_Dillon]

So, sync speed. Yes, a cloud database such as SQL will be faster on sync than GSheets. Especially if you use Security Filters.

Sync speed highly depends on a well setup app, as well as the amount of data. If you’re using lots of expensive virtual columns, it’s going to be slow no matter what backend you use. Search the community with the terms “sync” “speed” “performance”, etc, for more info. Like this post:

Performance improvement tips Tips & Tricks 💡

I was searching the archive for information about the “Worksheet bulk read” option for syncing data and came across these tips from Simon Robinson which sound very useful to me. However, I have some questions about them that I’d like to post below: URL: Hi What is best practice in terms of workshe... Tip 1 = The key thing to note first is Google Sheets will limit you to 2million cells per spreadsheet. So if you’re gonna go over that, then definitely look at having more than 1 spreadsheet f…