Hi Ben, How many records are you fetching at a time? Perhaps you want to limit the results you present at one time to 20 (or some other reasonable number), then use cursors to facilitate paging?
Robert On Tue, Jan 11, 2011 at 13:15, Benjamin <[email protected]> wrote: > Hi Everyone, > > A little challenge for the day - If I have many millions of an object > persisted in the datastore that have an two properties: a long value > and a date, and I want to query for a subset of those object that have > the same long value, and a date that falls between a start and end > date range. > > This is how i'm doing it: > > q = pm.newQuery(RecordedValue.class, > "pointFK== k && timestamp >= sd && timestamp > <= ed"); > q.declareImports("import java.util.Date"); > args = new HashMap<String, Object>(); > args.put("k", point.getId()); > args.put("sd", startDate); > args.put("ed", endDate); > > q.declareParameters("String k, Date sd, Date > ed"); > q.setOrdering("timestamp descending"); > data = (List<RecordedValue>) q > .executeWithMap(args); > > My users are experiencing "hard deadline exceeded errors" when trying > to pull this data. I was wondering if there was a better, more magical > way to do this query, or can i improve things with a better index > definition in my datastore-indexes file. > > Thanks! > > Ben > > -- > 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.
