OK, let me explain the query which I need to run (I am putting the sql server syntax for it, thats what I was working so far): select * from mytable where field1>=1000 and field2<=1000;
Thats what I need to run on on datastore. Field1 and field 2 are have a relation. More specifically, Field1 <=field 2. My db is such that when I search for any given integer say 1000, then the db will return only one row for given condition : field1>=1000 and field2<=1000; Regards, Romesh.. On Sat, May 1, 2010 at 4:42 PM, Tristan <[email protected]> wrote: > Hey, > > So, there's no more 1000 query limitation, that went away (unless it > was put back in). > > I see what you're saying though. Need to know more about what the > problem is. I assume x and z are the two properties? It seems that x > and z are correlated (since you guarantee that there is only one > solution that meets the criteria). This correlation can probably be > exploited to better solve the problem, but I need some constraints to > work with. What is the relationship between x and z that guarantees > you will have only one solution? > > Tristan > > > On May 1, 2:30 am, romesh soni <[email protected]> wrote: > > Hi Tristan, > > The solution you provided is the best one among of those which I have > found > > so far. But this is not what I was looking for, my database is quite > large > > and its will grow continuously to millions of records in time. But there > > will be only 1 matching record for my filter (x<=y and y>=z) If I try > your > > suggested approach, then I will have to scan all records in loop.(1000 > > limitation) > > > > On Fri, Apr 30, 2010 at 6:58 PM, Romesh <[email protected]> wrote: > > > I have been trying to find a workaround for this limitation and spent > > > 2 days and read almost all blogs, discussion > > > groups....................., but can not find a solution to it. Has > > > any one able to find a way to handle this limitation? (The List > > > property solution doesn't work.) > > > > -- > > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > > To post to this group, send email to > [email protected]. > > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > > For more options, visit this group athttp:// > groups.google.com/group/google-appengine-java?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" 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-java?hl=en.
