CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Tim van Zonneveld
Tim van Zonneveld

Reputation: 518

response time google spreadsheet with large number of rows

I'm developing a web application that will use a google spreadsheet as a database. This will mean parsing up to 30.000 (guestimated size) rows in regular operations for searching ID's etc...

I'm worried about the response times i will be looking at. Does anybody have experience with this? I don't want to waste my time on something that will hit a deadend at an issue like that.

Thanks in advance

Upvotes: 2

Views: 3296

Answers (2)

Henrique G. Abreu
Henrique G. Abreu

Reputation: 17752

Using spreadsheets as a database for this data set is probably not a good idea. Do you already have this spreadsheet set up?

30K rows will allow you to have only 66 columns, is that enough for you? Check the Google Docs size limits help page for more info.

Anyway, Google Spreadsheets have a "live concurrent editing" nature to it that makes it a much slower database than any other option. You should probably consider something else.

Upvotes: 2

Serge insas
Serge insas

Reputation: 46794

Do you intend to use the spreadsheet to display data or only as a storage place.?

In this second option the relative slowness of the spreadsheet will not be an issue since you'll only have to read its data once to get its data in an array and play with that...

This implies of course that you build every aspect of data reading and writing in a dedicated UI and never show the spreadsheet itself , the speed will be depending only on the JavaScript engine on arrays, the speed of UI and the speed of your internet connection... all 3 factors being not very performing if compared to a 'normal' application but with the advantage of being easily shareable and available anywhere.:-)

That said, I have written such a database app with about 20 columns of data and 1000 rows and it is perfectly useable although having some latency even for simple next / previous requests. On the other hand the app can send mails and create docs.... the advantages of Google service integration :-)

You could have a look at this example to see what I'm talking about

Upvotes: 1

Related Questions