did you make an error or are you describing this condition? 1000 <= field1 <= field2 <= 1000
On May 1, 10:26 am, romesh soni <[email protected]> wrote: > 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%2B > > [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%2B > > [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 > 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]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
