Results 1 to 3 of 3

Thread: Poor performance with Qt 4.3 and Microsoft SQL Server

  1. #1
    Join Date
    Oct 2007
    Posts
    3
    Qt products
    Qt4
    Platforms
    Windows

    Default Poor performance with Qt 4.3 and Microsoft SQL Server

    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?

  2. #2
    Join Date
    Jan 2006
    Location
    Warsaw, Poland
    Posts
    33,364
    Thanks
    3
    Thanked 5,014 Times in 4,792 Posts
    Qt products
    Qt3 Qt4 Qt5 Qt/Embedded
    Platforms
    Unix/X11 Windows Android Maemo/MeeGo
    Wiki edits
    10

    Default Re: Poor performance with Qt 4.3 and Microsoft SQL Server

    What happens if you access the same database using ODBC but not using Qt?

  3. #3
    Join Date
    Oct 2006
    Posts
    42
    Thanks
    1
    Thanked 8 Times in 8 Posts
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: Poor performance with Qt 4.3 and Microsoft SQL Server

    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/qsqlque...setForwardOnly

Similar Threads

  1. Sql Server and PDF files
    By kroenecker in forum General Programming
    Replies: 4
    Last Post: 26th June 2007, 10:50

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.