[MAPSERVER-USERS] ms sql 2008 spatial - still problems???

[Tamas Szekeres]

For those who interested, I've just fixed a memory corruption issue in
the MSSQL 2008 driver which might be related to the problems reported
below.
The corresponding ticket can be found here:
http://trac.osgeo.org/mapserver/ticket/2790

Check out the latest version and give it a try.

It must be noted that sometimes the query optimizer doesn't use the
spatial index by default, therefore you might want to force using it
to achieve the best performance, namely:

DATA "geom from mytable WITH(INDEX(geom_idx)) USING UNIQUE ID USING SRID=0"


By zooming out of the indexed area the query might become extremely
slow on large datasets, but otherwise the performance of the database
seems OK to me.

Best regards,

Tamas



2008/10/10 BrainDrain <paulborodaev at gmail.com>:
>
> sometimes access violation on mapObj construction ...
> only iisreset helps
> --
> View this message in context: http://www.nabble.com/ms-sql-2008-spatial---still-problems----tp19454300p19916793.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>