[google-appengine] Re: How much time to give for each db query in order not to occur DeadlineExceededError
I see, it seems to be the best solution right now:) thanks On Dec 23, 2:28 am, Marzia Niccolai ma...@google.com wrote: Hi, It's difficult to estimate the amount of time it takes to put() and delete() datastore entities because it depends a great deal on the size and shape of your entities. One thing you should do is call db.Put(entities) in one call, instead of multiple calls in one request to entity.put(). Also, you can't rely on the speed of the dev_appserver to be indicative of the speed on App Engine itself. The best advice I can give is, if you see the datastore is constantly timing out on a given request, reduce the number of entity updates in that request until you find the number that best fits your data. -Marzia On Sat, Dec 20, 2008 at 6:19 PM, Bob bobzs...@gmail.com wrote: Hi GAE team, how about the time for deleting? I think it would also encounter the DeadlineExceededError.. Thank you: On Dec 20, 11:52 pm, Bob bobzs...@gmail.com wrote: Too much db operations, it needs 10 seconds on my own computers to read the whole file to store in the datastore. But on the GAE, it occurs DeadlineExceededError. I gave 0.2 second for each db put(), it could work first but finally went wrong. I then gave 0.5 second and still could't solve the problem. How much time shall I give?? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---
[google-appengine] Re: How much time to give for each db query in order not to occur DeadlineExceededError
Hi, It's difficult to estimate the amount of time it takes to put() and delete() datastore entities because it depends a great deal on the size and shape of your entities. One thing you should do is call db.Put(entities) in one call, instead of multiple calls in one request to entity.put(). Also, you can't rely on the speed of the dev_appserver to be indicative of the speed on App Engine itself. The best advice I can give is, if you see the datastore is constantly timing out on a given request, reduce the number of entity updates in that request until you find the number that best fits your data. -Marzia On Sat, Dec 20, 2008 at 6:19 PM, Bob bobzs...@gmail.com wrote: Hi GAE team, how about the time for deleting? I think it would also encounter the DeadlineExceededError.. Thank you: On Dec 20, 11:52 pm, Bob bobzs...@gmail.com wrote: Too much db operations, it needs 10 seconds on my own computers to read the whole file to store in the datastore. But on the GAE, it occurs DeadlineExceededError. I gave 0.2 second for each db put(), it could work first but finally went wrong. I then gave 0.5 second and still could't solve the problem. How much time shall I give?? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---
[google-appengine] Re: How much time to give for each db query in order not to occur DeadlineExceededError
Hi GAE team, how about the time for deleting? I think it would also encounter the DeadlineExceededError.. Thank you: On Dec 20, 11:52 pm, Bob bobzs...@gmail.com wrote: Too much db operations, it needs 10 seconds on my own computers to read the whole file to store in the datastore. But on the GAE, it occurs DeadlineExceededError. I gave 0.2 second for each db put(), it could work first but finally went wrong. I then gave 0.5 second and still could't solve the problem. How much time shall I give?? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~--~~~~--~~--~--~---