Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Really poor performance of ODBC Driver when talking to MS-SQL Express

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

Scheduled Pinned Locked Moved Unsolved General and Desktop
2 Posts 1 Posters 494 Views
  • 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 Offline
    W Offline
    Wurgl
    wrote on last edited by
    #1

    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
    0
    • W Offline
      W Offline
      Wurgl
      wrote on last edited by
      #2

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

      1 Reply Last reply
      0

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved