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.
