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 <[EMAIL PROTECTED]>: > > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
