[OSM-dev] Spatial vs. multi-column indexes for points

[Marcus Wolschon]

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 <sascha-ml-gis-osm-dev at silbe.org> 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
> 
>