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: 180
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