Timeout if too many rows already in the sheet

[Isabellle]

Thanks a lof for this library. Already using it, but it seems that your class get a timeout as soon as there too many data in the sheet (1600 rows in my case). When I want to dynamically add a single row, I get a timeout response even when adding this ini_set("memory_limit",'32M');

Have you already heard about this?

Thanks a lot, Isabelle,

[mike-rsi]

Hi Isabelle,

This is because adding rows to Google Spreadsheets through the GData API becomes slower as worksheet size increases. This isn't a bug in this library specifically.

The PHP setting you're looking for to help alleviate this problem is "max_execution_time" value defined in the php.ini. You can set this at run time with the function set_time_limit().

Note: if you're calling your PHP through FastCGI, etc., there may be other time outs (e.g. gateway time outs) that will become a problem as well. See your web server's documentation if you run into this problem.

HTH.

[farinspace]

This class is definitely a light weight solution to data collection, I've used it for a while and have come to that conclusion. I started work on a different version of the library, using just php and google api (bypassing zend, which i think is a source of slowness), but as with things in life cooler more exciting things come along.

Setting the "max_execution_time" will help, but it will just be a band-aid until the sheet grows further.