Qt Forum
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

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

    General and Desktop
    1
    2
    378
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • W
      Wurgl last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • W
        Wurgl last edited by

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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post