Hi, We seem to be hitting some weird limit and super slowness on the Google Sheet API.
We have a process that consists in creating a fairly large sheet (over 100k cells) and then issuing a batch request with two AutoResizeDimensionsRequest for both ROWS and COLUMNS on the entire spreadsheet. Note that instead of issuing a single UpdateCellsRequest, we issue about 10 requests in parallel with 1/10th of the data each time to avoid breaching the request size limit of 10MB. It's only 500 rows per batch, but those a quite wide (20+ columns) and the styling on them ends up creating very verbose JSON which can expand to quite a few MB even though the compressed size is much smaller. This takes about 65 seconds, which seems reasonable. Then we issue the 2 auto-resize requests in a single batch request, which takes 140 seconds on average! We don't understand why it takes so long. Could the auto-resize requests be throttled because of all the data just uploaded before? Any guidance on how to avoid tripping quotas and throttle would be much appreciated. Is it possible to create a cell style and re-use the style to multiple cells to avoid the inline of styling in the JSON for all rows and therefore reducing the total JSON size? Thanks in advance, Clement -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
