Poor performance with Qt 4.3 and Microsoft SQL Server

[Korgen]

We use the ODBC plugin of Qt 4.3.1 to access a Microsoft SQL Server 2005. We encounter very bad performance - 10 times worse than accessing a oracle server with ODBC.

There was often the suggestion to use the TDS plugin. But we did made some tests and discovered some problems using this plugin. So we have to stay with the ODBC plugin.

Do you have experience in accessing a Microsoft SQL Server database with Qt? Can you give me a solution for the performance problem?

[wysota]

What happens if you access the same database using ODBC but not using Qt?

[mm78]

If you need only to scroll forwards trough the results you can set the queries to forwardOnly mode which should cause a speed up for MS SQL Server.

http://doc.trolltech.com/4.3/qsqlquery.html#setForwardOnly