Results 1 to 2 of 2

Thread: Lag of Performance using QT3.3.3 to get access to a MS SQL Server

  1. #1
    Join Date
    Oct 2006
    Posts
    1
    Qt products
    Qt3
    Platforms
    Windows

    Default Lag of Performance using QT3.3.3 to get access to a MS SQL Server

    We are using the QT3 Framework with the ODBC Driver to get access to a MS SQL Server and we really liked the simple high-lvl-API at the start, but now we experience a really bad performance.
    The DB Server runs on a remote machine and we access it via the internet. A simple SQL query, which returns 1800 table rows takes us around 90 seconds, which is really dissatisfying.
    The same query on a local copy of the database (MS Access DB) takes us around 1 second. Our guess is that this real big difference between this two measurements is because of the overhead of data packages and number of requests (one for each row) used to communicate with the remote server.
    Our general understatement of the QSqlSelectCursor or QSqlQuery is the following:

    1. initializing the query/cursor with the predefined query-statement
    2. iterating the query/cursor with next() to get the single rows for further use
    3. repeating step 2 until the end of the query/cursor

    Does anyone know how QT manages the query results and does QT always send a new fetch request, every time we use next()? Or is there some way to get a local copy of the result (caching) we can work with to we skip the overhead?

    Has anybody experienced similar problems using QT3 or got a solution for this performance problem?

    Thanks in advance!

  2. #2
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    5,372
    Thanks
    28
    Thanked 975 Times in 912 Posts
    Qt products
    Qt3 Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Lag of Performance using QT3.3.3 to get access to a MS SQL Server

    The problem might be in ODBC. Try the QTDS driver.

Similar Threads

  1. Sql Server and PDF files
    By kroenecker in forum General Programming
    Replies: 4
    Last Post: 26th June 2007, 10:50
  2. Sql Server cannot retrieve data from select
    By Atomino in forum Qt Programming
    Replies: 10
    Last Post: 7th September 2006, 16:37
  3. connect to sql server
    By raphaelf in forum Qt Programming
    Replies: 15
    Last Post: 27th February 2006, 18:06

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.