Hi Mark, On Tue, Sep 22, 2009 at 8:11 AM, Mark.T <m...@sammaajiva.com> wrote: > > > Well, good question. Our host GoDaddy, took a look and said that is > definitely not the server. Their best guess was that the code may only > be trying to get a small amount of data but the traffic the request is > generating is enormous, totally out of propostion.
I would imagine the issue is to do with the amount of memory a PHP process is able to use per script execution. Have you tried running this script on a local computer where you might be able to give it all the memory it needs to perform its task? > The analogy used was that it was like loading up all the phone books > for the USA into memory then extracting the one page of numbers > actually required. The equivalent scenario would be the API needing to > retrieve every doc in the account before narrowing down to the one doc > required. > Obviously the other way of doing this breaking this queries up into parts so you don't load all the data into the memory of your server in one shot. Depending on how intensive your application is you might even want to consider a different host. > You may be able to tell that I am not the programmer so my analogies > may be off the mark. > We will do the best we can to help you sort the issue. Just got to keep providing us with as much information as you possibly can. > Even thought we are specifying the document and worksheet we want to > read, could some error on our part produce the symptoms described? > -- "The secret impresses no-one, the trick you use it for is everything" - Alfred Borden (The Prestiege) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
