Really poor performance of ODBC Driver when talking to MS-SQL Express



  • When I use a set of queries with QT and its ODBC3 SQL driver, it takes 50 seconds when client and server is on the same machine.

    The same set of queries take 500 seconds when the client is on a different machine and connected via WLAN.

    The same set of queries processed with MS-program sqlcmd (which comes with sql express installation) takes 5 seconds local and 10 seconds over that WLAN.

    If needed I can provide a test program, but first I try to asked without it. Does anybody have a similar experience?



  • Seems that I need QSqlQuery::setForwardOnly(true). Default is "false" causing this poor performance.


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.