PDA

View Full Version : Poor performance with Qt 4.3 and Microsoft SQL Server



Korgen
29th October 2007, 11:52
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
22nd November 2007, 11:33
What happens if you access the same database using ODBC but not using Qt?

mm78
23rd November 2007, 11:28
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