your right. didnt have the time yet to find out what the difference is but i will. another possible option is that ndb is making async gets for the keys compared to the db...
On Mar 21, 2012, at 8:45 PM, Jeff Schnitzer wrote: > If I had to guess, I would suspect the difference is NDB's caching > layer pulling data from memcache. But I don't know. The only way to > find out is to run appstats and find out what's actually going on. > Stop speculating, start measuring. It's the same datastore > underneath. > > Jeff > > On Wed, Mar 21, 2012 at 8:26 PM, Andreas <[email protected]> wrote: >> i mean with query here i dont really mean querying and filtering. i have a >> list of keys and i get() them. >> what is going on i think is that ndb does the query a bit smarter than the >> db module. >> >> ndb is consistently under 1s while db takes multiple seconds. >> >> >> On Mar 21, 2012, at 7:14 PM, Jeff Schnitzer wrote: >> >>> There are a lot of possible answers to that question. Have you >>> enabled appstats? That is the best way to figure out what is actually >>> going on. >>> >>> Jeff >>> >>> On Wed, Mar 21, 2012 at 4:45 PM, Andreas <[email protected]> wrote: >>>> tested ndb.ge_multi(). the same query with the same keys takes 0.7 >>>> seconds.... how is this possible? >>>> >>>> On Mar 21, 2012, at 3:49 PM, Andreas wrote: >>>> >>>> ok guys now fetching 500 entities by keys as strings takes something >>>> between >>>> 8-10 seconds?!! >>>> 3s was already too much... 10 is not acceptable. >>>> >>>> On Feb 18, 2012, at 11:17 AM, GordonHo wrote: >>>> >>>> i am having a similiar problem. >>>> occasionally i need to fetch all entities of a given table (about 5000) - >>>> this really takes way too long (talking about ~40-60seconds). >>>> >>>> so far i haven'd found an easy to to fetch lots of entities from the >>>> datastore. at some point i probably will create one big fat entity >>>> containing all others, but this will involve quite some work.. >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "Google App Engine" group. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msg/google-appengine/-/x0OAOy9ft0cJ. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/google-appengine?hl=en. >>>> >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "Google App Engine" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]. >>>> For more options, visit this group at >>>> http://groups.google.com/group/google-appengine?hl=en. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Google App Engine" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/google-appengine?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/google-appengine?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
