another puzzling thing about this query ... it is only really slow when the offset is 0 (or a very low value)
it runs less a second when the offset is larger, like 1000 is there something strange when you are trying to find the most recent blobs created, even if the creation happened hours (or days) earlier? On Sat, Nov 19, 2011 at 5:44 PM, James Gilliam <[email protected]> wrote: > Any ideas on why Blobstore -creation query runs so slow ... like 20 > seconds for 1500 blobs. > > Doing this query > > aQuery = blobstore.BlobInfo.all() > aQuery.order( '-creation' ) > aBlobstore = aQuery.fetch( 5, 0 ) > > I even tired building an explicit index for creation but got an error > that said that it is always built and to remove this from your > index.yaml file. > > So, there apparently is an index and let this query runs very slow. > > Any ideas? > > p.s. I also do a similiar query adding a filter for filename and > specify a compound index and that one runs ok. -- 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.
