search

asimlqt / php-google-spreadsheet-client

A PHP library for accessing and manipulating Google Spreadsheets
Other
544 stars 152 forks source link

Reduce Time #114

Closed MULLAINATHAN closed 8 years ago

MULLAINATHAN commented 8 years ago

Hi All, I have 40,000 rows. When I try to insert, it took long time (~ 30 minutes). Is it possible to reduce insertion time. Please help me.

Dartui commented 8 years ago

I guess that there is no way to reduce time, but there are two ways to insert data:

  1. slower: https://github.com/asimlqt/php-google-spreadsheet-client#adding-a-list-row
  2. faster: https://github.com/asimlqt/php-google-spreadsheet-client#updating-multiple-cells-with-a-batch-request

If you are using first, try to change it to 2nd.