[OSM-dev] Best and FASTEST Spatial DB for only calculating points near to X?

Oliver Tonnhofer olt at omniscale.de
Sat Dec 15 14:05:58 GMT 2012


On 15.12.2012, at 14:18, Ander Pijoan wrote: 
> This is a good point. I know more or less how PostGIS works and how I should structure the query.
>  
> My question was more related to fastness. The type of queries will just be some "geoNear" queries, just to get all the points within a bounding box that match certain value.

Check out the nearest neighbor search feature of PostGIS 2.0. See: http://workshops.opengeo.org/postgis-intro/knn.html

> I know that PostGIS is a better GIS and provides far more features, but just for geoNear queries and taking into account that MongoDB (for what I've been reading) is supposed to be more web-scalable and easier to export to JSON I think I will try booth.

Webscale. Nice.

Do you have any numbers for your requirements? Like the number of queries per second and the number of records in your database?

Regards,
Oliver




More information about the dev mailing list