Database/NoSQL - Lowest latecy way to retreive the following data...

Posted by Nickb on Stack Overflow See other posts from Stack Overflow or by Nickb
Published on 2010-05-09T18:27:20Z Indexed on 2010/05/09 18:28 UTC
Read the original article Hit count: 148

Filed under:
|
|
|
|

I have a real estate application and a "house" contains the following information:

house:
- house_id 
- address
- city 
- state
- zip
- price
- sqft
- bedrooms
- bathrooms
- geo_latitude
- geo_longitude

I need to perform an EXTREMELY fast (low latency) retrieval of all homes within a geo-coordinate box.

Something like the SQL below (if I were to use a database):

SELECT * from houses 
WHERE latitude IS BETWEEN xxx AND yyy
AND longitude IS BETWEEN www AND zzz

Question: What would be the quickest way for me to store this information so that I can perform the fastest retrieval of data based on latitude & longitude? (e.g. database, NoSQL, memcache, etc)?

© Stack Overflow or respective owner

Related posts about Performance

Related posts about nosql