Hello. Is there amy kind of embeddable (java) database or database I can expect an end-user to install (no PostGIS or manually installing the mysql-gis-extension) that supports spatial indice?
I tried storing a z-tree of the coordinates in one indexed column in HSQLDB and the performance was worse then using a multi-column -index. Thanks, Marcus On Thu, 11 Sep 2008 14:14:52 +0200, Sascha Silbe <[EMAIL PROTECTED]> wrote: > 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 > > _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
