Thanks Robert, what i ended up doing was limiting the request to 1000
at a time and then making more round trips to build a collection until
the result was zero.
On Jan 12, 2:18 pm, Robert Kluin <robert.kl...@gmail.com> wrote:
> 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 <bsaut...@gmail.com> 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 google-appengine@googlegroups.com.
> > To unsubscribe from this group, send email to
> > google-appengine+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://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 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.
