Maxim, I just wanted to mention how we handle queries like these. Ikai already pointed you to some good stuff for handling the geographical part of the queries. To handle searching on other "ranges" we add "summary fields" (or entries to a specially crafted list).
In some of our queries we need to query by a date and price range. To accomplish the date part of this we break the date down into year, quarter, and month properties. We then look at the range we are querying, choose the most restrictive of those properties, do an equality filter on that property, and filter the results in code. The price range is something similar. In your case you might want to just define common sm and price ranges that are stored then use in code filtering for refining the results. Robert On Wed, Feb 24, 2010 at 2:08 PM, Ikai L (Google) <[email protected]> wrote: > Here's kind of an interesting post on a similar subject: > http://labs.metacarta.com/blog/27.entry/geographic-queries-on-google-app-engine/ > Your problem may be best solved by geohash. I'd search for more tutorials > about Geohash and App Engine. Someone on the Google Geo API team wrote an > article on it, but I don't have the link ready. > StackOverflow discussion: > http://stackoverflow.com/questions/2060219/google-app-engine-geohashing > > On Wed, Feb 24, 2010 at 12:45 AM, megaswin <[email protected]> wrote: >> >> Hi guys, >> >> I've got a small question. I have a database where I store information >> about houses and now I want to be able to find all houses that meet >> these criteria : >> size is more than 150sm and less than 200sm, price is in range [200K , >> 250K], located in this bounds [GeoPoint northWest, GeoPoint >> southEast]. So am I right in thinking that i'm in big trouble. Is >> there a cure? I have only one idea : extract all entries from db and >> then filter these entries "maually". My db can contain up to 50K >> entries, so in your opinion, is it normal to parse such nuber of >> objects inside http request? any thought? >> >> Thanks. >> Maxim >> >> -- >> 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. >> > > > > -- > Ikai Lan > Developer Programs Engineer, Google App Engine > http://googleappengine.blogspot.com | http://twitter.com/app_engine > > -- > 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.
