Outgrown 100,000 rows in spreadsheet. How to scale up?

I’m trying to import a spreadsheet with more than a million rows. How do I handle this while using the Appsheet interface? Ideas?

Waw… are you using google sheet?

1 Like

Yes, lol. I’ve been using a combination of Excel and Google sheets.

I heard someone talk about MySQL so curious how people would handle massive databases with streamlined front end. Ideas?

For an app this size, you really need to migrate to a real SQL server. I expect Google Sheets / Excel would run very slow.

2 Likes

Even on a database 1 million rows will slightly chug unless your table is still small in overall size. Performing any virtual columns beyond the most basic on this table will eat your performance as well.

1 Like