[Interest] [Help]A big problem about accessing database using OCI driver plugin from qt application.‏

Lincoln Ramsay a1291762 at gmail.com
Mon Oct 29 12:40:32 CET 2012

On 29/10/12 11:22 AM, Xiaognag Wang wrote:
> 3. the problem is: it is too slow to get data from database, for 
> example:  get 20000 records from database will spend 7 seconds, if I 
> use odbc instead, it will just need about 30 ms.
> Does anyone have experience about this? Could you please give a 
> suggestion for me?

Did you enable caching of any kind?

You might get row caching by default with odbc but I don't believe that 
is on by default with Qt SQL. It makes a big performance difference when 
you want to iterate over lots of rows of data returned from a query.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.qt-project.org/pipermail/interest/attachments/20121029/f24e0774/attachment.html>

More information about the Interest mailing list