Database / NoSQL - Least Delay Method for Retrieving the Following Data

Question

I have a real estate application, and the “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 (with a small delay) extraction of all houses in the geo-coordinate snap window .

Something like SQL below (if I have 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 fastest way to store this information so that I can perform a quick data search based on latitude and longitude? (e.g. database, NoSQL, memcache, etc.)?

Answer 1

(). . , .

, , , , . , , , .

Answer 2

ThereMongoDB , . , , "", , , , .

, , .

Answer 3

, , , , . , , , ​​ sqlite ( ) mysql, SQL, .

Most (not all) NoSQL databases are ultimately too complex for queries of this type, since they are better off looking for exact values ​​in their indexes rather than in ranges.

It's good that you are looking for a restrictive box instead of a Cartesian distance; it would be more difficult for the latter to optimize the SQL database (although you could narrow it to a bounding box, then perform a slower Cartesian distance calculation).