I can't imagine what your data is. Is it possible to pre-solve the solution list z for every (x, y) pair and store them like (x, y, list of z). If it is the case, you can use a simple z=<somevalue> filter to get your single result.
Thomas On 5月2日, 下午4時57分, romesh soni <[email protected]> wrote: > Tristan, > > sorry for the mistake. I wrote the wrong thing ( I realized this at night > when I went to bed for sleep) > It is field1<=1000<=field2. A given value will always be between the lower > and upper bound (field1 and field2). > > Thanks > Romesh > > On Sun, May 2, 2010 at 11:20 AM, Tristan <[email protected]>wrote: > > > > > 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%[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%[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]<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 > 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.
