{"action":"created","issue":{"url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client/issues/44","repository_url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client","labels_url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client/issues/44/comments","events_url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client/issues/44/events","html_url":"https://github.com/asimlqt/php-google-spreadsheet-client/issues/44","id":53342562,"number":44,"title":"Replace CURL with Guzzle to allow for concurrent inserts","user":{"login":"j0rd","id":373320,"avatar_url":"https://avatars.githubusercontent.com/u/373320?v=3","gravatar_id":"","url":"https://api.github.com/users/j0rd","html_url":"https://github.com/j0rd","followers_url":"https://api.github.com/users/j0rd/followers","following_url":"https://api.github.com/users/j0rd/following{/other_user}","gists_url":"https://api.github.com/users/j0rd/gists{/gist_id}","starred_url":"https://api.github.com/users/j0rd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/j0rd/subscriptions","organizations_url":"https://api.github.com/users/j0rd/orgs","repos_url":"https://api.github.com/users/j0rd/repos","events_url":"https://api.github.com/users/j0rd/events{/privacy}","received_events_url":"https://api.github.com/users/j0rd/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-04T17:35:28Z","updated_at":"2016-03-14T11:05:27Z","closed_at":"2016-03-14T11:05:27Z","body":"I'm using this library to create a fairly large spreadsheet multiple times a day (stock lists in a collection of ecommerce stores). Every hour, I'd like to do around 6000 rows.\r\n\r\nProblem is right now $row->insert() requires a POST per insert. This makes it fairly slow. I've tried POSTing multiple entries in a POST to increase the throughput, but Google does not allow this.\r\n\r\nFrom the docs, I can't find any other instance where bulk inserts are allowed either.\r\n\r\nBecause of this, I suggest perhaps using the Guzzle library to allow multiple concurrent inserts to happen at once.\r\n\r\nHere's the docs for something like that:\r\nhttp://docs.guzzlephp.org/en/latest/clients.html#sending-requests-with-a-pool\r\n\r\nThe API is also much friendlier to use that straight CURL. It does use CURL on the backend though.\r\n\r\nIf there's another way to send multiple inserts in a single POST than that would also work fine for me as well. Is this something which can get done with BatchRequest.php?"},"comment":{"url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client/issues/comments/196261019","html_url":"https://github.com/asimlqt/php-google-spreadsheet-client/issues/44#issuecomment-196261019","issue_url":"https://api.github.com/repos/asimlqt/php-google-spreadsheet-client/issues/44","id":196261019,"user":{"login":"asimlqt","id":1963846,"avatar_url":"https://avatars.githubusercontent.com/u/1963846?v=3","gravatar_id":"","url":"https://api.github.com/users/asimlqt","html_url":"https://github.com/asimlqt","followers_url":"https://api.github.com/users/asimlqt/followers","following_url":"https://api.github.com/users/asimlqt/following{/other_user}","gists_url":"https://api.github.com/users/asimlqt/gists{/gist_id}","starred_url":"https://api.github.com/users/asimlqt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asimlqt/subscriptions","organizations_url":"https://api.github.com/users/asimlqt/orgs","repos_url":"https://api.github.com/users/asimlqt/repos","events_url":"https://api.github.com/users/asimlqt/events{/privacy}","received_events_url":"https://api.github.com/users/asimlqt/received_events","type":"User","site_admin":false},"created_at":"2016-03-14T11:05:27Z","updated_at":"2016-03-14T11:05:27Z","body":"I would love t do this but I don't think it's going to be possible due to the way composer manages dependencies. It's not possible to have have 2 different versions of the same package running at the same time. Guzzle is a really popular library and will most likely be already used in most projects that use composer (we use it extensively at work)."}}