Thomas, it is possible to pre-determine the solution list for given lower and upper bounds x and y. But there can be enormous rows for a given (x,y) pair. And there will be enormous rows containing (x,y) pairs. So I can not keep a predetermined list.
Regards Romesh On Mon, May 3, 2010 at 5:52 AM, Thomas <[email protected]> wrote: > 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%[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%[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]> > <google-appengine-java%[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]> > <google-appengine-java%[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]<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.
