Re: Queries to big Google spreadsheets are slow

[jp.k...@gmail.com]

I also ran into the same problem. I've started to put all my data directly into my code rather than querying my Google Spreadsheet. It cuts a few seconds off. But definitely not the ideal solution.

On Thursday, May 16, 2013 5:22:42 AM UTC-4, Romain Vialard wrote:

Hi,

We use the Google Visualization API to display a table along with some filters (like in this example).

The data is stored in a Google Spreadsheet and we use a query to fetch it. But this ss contains a lot of data and Google is slow to answer, even if we query only a small subset of the data (we usually have to wait 6 to 8 seconds before the spreadsheet begins to answer)

Is there a way to improve that? Or is there any plan to increase those perfs on Google side ?

[Romain Vialard]

Indeed. We use a spreadsheet primarily because it's easy to update. We can't have a static database.

[Sergey Grabkovsky]

Unfortunately there's nothing that either we or you can do to improve the response speed from Google Spreadsheets. I can't imagine that this is a consistent issue for everyone (I got ~350ms for your spreadsheet), and it probably varies from day to day. Are there a lot of user complaints about it being slow? Or is this from testing on your own? Have you tried different computers with different internet connections?

- Sergey

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Romain Vialard]

Hi Sergey,

The spreadsheet in my example contains at most 50 rows and it answers fast, no issue. I didn't give access to the real spreadsheet which contains around 200 000 cells and on which we have an issue. 

It is a consistent issue. We have tried with multiple users, on multiple computers and with different internet connections.

And it keeps getting slower and slower. So I did a test and created a copy of the spreadsheet. I have no problem with that copy. So the big revision history on my original spreadsheet might cause the issue. Would that be possible ?

[Sergey Grabkovsky]

So I asked around, and it seems that the revision history probably isn't causing your issue. Your problem is likely caused by the fact that in order to get any data from a spreadsheet, docs first needs to open, load, and calculate formulas for the entire spreadsheet. In the case of 200,000 cells, that may be slow. I guess I'd advise some automated process to copy the data (not the formulas) from the slow spreadsheet into a new spreadsheet so that it only has to load everything.

- Sergey

--

[Romain Vialard]

Thank you Sergey. Sadly formulas can't be an issue here as I don't have any in this spreadsheet :P

[Sergey Grabkovsky]

I'm terribly sorry that I can't offer you any more help. The best I can do is refer you to the Google docs forum and hopefully they'll be able to help you there.

- Sergey

On Wed, May 22, 2013 at 1:46 PM, Romain Vialard <romain....@gmail.com> wrote:

Thank you Sergey. Sadly formulas can't be an issue here as I don't have any in this spreadsheet :P

--

[Sergey Grabkovsky]

Here are some more pages on the limitations of docs: Google spreadsheets size and complexity limits and Google Docs, Sheets, and Slides size limits.

- Sergey