On Thu, Sep 11, 2008 at 01:49:55PM +0200, Andreas Kalsch wrote:
Has anybody used GIS successfully in MySQL or PGSQL and can tell me how the performance compares between the two techniques?At least in PostgreSQL/PostGIS, the geometric indices are WAY faster. Just remember to either use the ST_* family of predicates (implicit bounding box scan) or add an "&&" term to do an explicit bounding box scan so the index is actually used.
CU Sascha -- http://sascha.silbe.org/ http://www.infra-silbe.de/
signature.asc
Description: Digital signature
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
