Your biggest problem is that you don't have the index needed to
perform the query if you have a pool of 20 parameters to choose from,
and you can pick any number of them.
For 20 parameters that is Total[Table[Binomial[20, k], {k, 1,
20}]]=1048575 distinct indices.
A bit too much for GAE for one application. That will be one heck of
an index.yaml file.If you have more then one parameter with an inequality the query is impossible on GAE. You have to do some simplification and after retrieving the results do some extra filtering, filter the second inequality. 2009/12/30 Diligent <[email protected]>: > In trying to make a transition from a purely PHP/MySQL background to > AppEngine's Python/Datastore I find myself not quite getting done what > I need. > Currently I have a web application in which a user chooses multiple > search criteria via an HTML form and passes those variables to a PHP > script that in turn queries a MySQL database and then displays the > results based on what they were looking for. > > The data is largely static in that it doesn't get changed or added to > very often but the specifics that a user searches on can vary greatly, > eg., > SELECT * FROM widgets WHERE color = 'blue'; > or > SELECT * FROM widgets WHERE color = 'orange' && weight < 3; > etc. (From the search form the user can choose from 1 to 20 different > criteria). > > I've been doing a lot of reading and a LOT of Google searching looking > for an example of what I am trying to accomplish, which one wouldn't > think would be difficult to get results since I'm just basically > wanting to submit multiple search criteria against the datastore and > retrieving the relevant results. > > At this point I would ask and greatly appreciate a pointer, an > example, a link to somewhere or anything that could help me in my > endeavor so I may get myself back on track. > > Will go back to reading the docs and I thank you for your time, > Q. > > -- > > You received this message because you are subscribed to the Google Groups > "Google App Engine" 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?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" 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?hl=en.
