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

[Martin Icking]

Hi Seth,
here the relevant (anonymized) sections in the mapfile:
    CONNECTION
"MSSQL:Server=myserver;uid=user;pwd=password;Database=mydatabase;Integrated
Security=false"
    CONNECTIONTYPE OGR
    DATA "SELECT * FROM ASSETS.Parcels"

As a consequence of the slow OGR performance we didn't do lot of SQL Server
profiling (do you have a link for a good description on this?) but we
switched back to the MS plugin. Fixing the code to correctly support the
"gml_types" "auto" clause was not too difficult. (Will create a pull request
about this fix soon).
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-tp5259922p5260311.html
Sent from the Mapserver - User mailing list archive at Nabble.com.