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
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