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.
