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 On Thu, May 16, 2013 at 12:27 PM, Romain Vialard <[email protected]>wrote: > 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 ? > > -- > 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.
