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 On Thu, May 16, 2013 at 10:47 AM, Romain Vialard <[email protected]>wrote: > Indeed. We use a spreadsheet primarily because it's easy to update. We > can't have a static database. > > > On Thursday, May 16, 2013 4:01:02 PM UTC+2, [email protected] wrote: >> >> 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<https://sites.google.com/site/scriptsexamples/available-web-apps/awesome-tables/people-directory> >>> ). >>> >>> >>> >>> <https://lh4.googleusercontent.com/-gplvtDjIoMc/UZSiNVGmDGI/AAAAAAAAEk4/y9qtdj6zrEY/s1600/Screen+Shot+2013-05-16+at+11.05.20+AM.png> >>> >>> 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) >>> >>> >>> <https://lh4.googleusercontent.com/-I6h77oTo9gs/UZSkN1to9jI/AAAAAAAAElI/DfbjiwU_Ph0/s1600/Screen+Shot+2013-05-16+at+11.17.15+AM.png> >>> >>> Is there a way to improve that? Or is there any plan to increase those >>> perfs on Google side ? >>> >>> >>> >>> -- > 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 [email protected]. > To post to this group, send email to > [email protected]. > 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. > > > -- 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 [email protected]. To post to this group, send email to [email protected]. 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.
