oracle Database performance in QT

**gbaguma** · 2nd August 2013, 07:41

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

**KaptainKarl** · 2nd August 2013, 20:29

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

**ChrisW67** · 3rd August 2013, 01:23

Originally Posted by gbaguma

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?