[mapserver-users] MS SQL server - OGR 5 times slower compared to Mapserver plugin?

[Seth G]

Hi,

I'd be interested in your experience with this, as I'm considering 
migrating to a Linux server from Windows, but could then no longer use 
the MapServer SQLServer driver.

What does your connection string look like? There are options for 
GeometryFormat - and using wkt has a significant overhead - 
http://www.gdal.org/drv_mssqlspatial.html
However the default is "native" so should not be an issue unless you 
overrode it.

Did you run the SQL Server profiler to see if the generated SQL looks 
any different using the OGR driver from the MapServer one?

Seth

On 06/04/2016 12:55, Martin Icking wrote:
> We noticed that typical WMS response times using the OGR layer type for MS
> SQL server are 5 times slower  compared to the MapServer MS SQL plugin.
> Maybe the OGR driver does not properly use the spatial index and always
> let's MapServer filter the relevant geometries? Do other users have a
> similar experience?
> At least that would make the OGR layer type unusable for us in this case. We
> understand that OGR layers have an extra level of abstraction but that
> should not create such a big performance penalty. Any hints to make the OGR
> layer faster?
>
> The reason that we switched from Plugin to OGR was that the Plugin does not
> properly support the "gml_types" "auto" clause and always reports the column
> types as string.
> Tx
> Martin
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/MS-SQL-server-OGR-5-times-slower-compared-to-Mapserver-plugin-tp5259922.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