Results 1 to 3 of 3

Thread: oracle Database performance in QT

  1. #1
    Join Date
    Jul 2013
    Posts
    8
    Thanks
    3
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    Unix/X11 Windows

    Default oracle Database performance in QT

    Hey guys
    Am wondering what is the best way to speed up the operation of querries to oracle. Am running querries that seem to take about 7 - 20 seconds to return the data using QtSqlQuerry. The same happens with the model class as well. However when i run these same querries in sql developer it just takes a few millseconds for the data to be returned. is there some particular way of returning this data faster,...surely 200 -1000 rows of data should not be that big of an issue for Oracle to return. is there something am doing wrong

  2. #2
    Join Date
    Feb 2006
    Location
    Jarrell, Texas, USA
    Posts
    70
    Thanks
    7
    Thanked 4 Times in 4 Posts
    Qt products
    Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows Android

    Default Re: oracle Database performance in QT

    Did you build the native OCI plugin or are you using the ODBC driver?
    You will get far better performance with the native driver.

    Karl

  3. #3
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,734
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: oracle Database performance in QT

    Quote Originally Posted by gbaguma View Post
    is there something am doing wrong
    Maybe, but it very hard for us to say because we cannot see what you are doing.

    What are the queries?
    Using a QSqlsomethingModel or a bare QSqlQuery?
    When you say "data to be returned" do you mean all columns of all rows returned by the query, or the first rows of data?
    What are you doing with the rows returned? Displayed in a view or processed internally?
    Are you sorting or filtering in code rather than at the server?

Similar Threads

  1. Error connecting to Oracle database
    By NAYZAKAY44 in forum Qt Programming
    Replies: 1
    Last Post: 2nd August 2013, 18:20
  2. Qt Oracle Database Failure...
    By combsjy in forum Qt Programming
    Replies: 0
    Last Post: 9th August 2010, 15:57
  3. Oracle Database Connection
    By ToddAtWSU in forum Qt Programming
    Replies: 6
    Last Post: 20th December 2007, 15:18
  4. Oracle database <=> Qt4/Opensource
    By windkracht8 in forum Qt Programming
    Replies: 1
    Last Post: 23rd May 2007, 23:12
  5. Oracle Database Problem
    By magikalpnoi in forum Qt Programming
    Replies: 3
    Last Post: 27th September 2006, 21:19

Tags for this Thread

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.