Re: [google-appengine] Re: What's the fastest way to get the 1st and last item from a result?

2010-04-06 Thread Wesley C (Google)
agreeing with ryan here that you'll need to do a pair of questions, regardless of whether you do it via a Query or GqlQuery. however, a better question would be: what are you trying to do, and why do you need the first and last keys? non-relational datastores are generally not geared up for doing

Re: [google-appengine] Re: What's the fastest way to get the 1st and last item from a result?

2010-04-06 Thread José Moreira
Hi i posed the question to optimize this tool i was working on http://github.com/matrixownsyou/MultiTaskBob it works by serially segmenting records in buckets of X records, by the keys: segemnt1, startkey1, endkey2 segemnt2, startkey3, endkey4 this should be fast since it only selects

Re: [google-appengine] Re: What's the fastest way to get the 1st and last item from a result?

2010-04-06 Thread José Moreira
btw the datastore in wich i was ask to do a ask and for which i developed the tool, i was told it holded million records initially but it had 45 million after all, so the meta refresh trick didnt hold here. my colleague ended up not using the tool :/ No dia 6 de Abril de 2010 23:41, José

[google-appengine] Re: What's the fastest way to get the 1st and last item from a result?

2010-03-29 Thread ryan
On Mar 29, 6:01 pm, José Moreira matrixowns...@gmail.com wrote: but both take too long (7/8 seconds at least). Should i refactor to GQL for example and do 2 SELECT's? One for the 1st and another for the 2nd? yes. it doesn't matter whether you use GQL or programmatic queries, but you definitely