[Interest] [Help]A big problem about accessing database using OCI driver plugin from qt application.
xiaogangwang2012 at hotmail.com
Wed Oct 31 08:37:02 CET 2012
Your solution is great.When I set OCI_ATTR_PREFETCH_ROWS option, the accessing speed becomes so fast. Thank you so much :)
Have good time!BR,Eric2012.10.31
Date: Tue, 30 Oct 2012 20:13:19 +1000
From: a1291762 at gmail.com
To: xiaogangwang2012 at hotmail.com; interest at qt-project.org
Subject: Re: [Interest] [Help]A big problem about accessing database using OCI driver plugin from qt application.
On 30/10/12 5:25 PM, Xiaognag Wang
You mean this big difference (7 seconds and 30 millisecond ) was
caused by cache?
Oh yes. There's a big difference between having 1 chunk of data sent
from the server to the client and having the client poll the server
every time your app says fetchNext(); The effect becomes even more
pronounced as you increase the latency between your app and the
database server (eg. if it's on a network instead of on the local
In my testing, query.next() just retured 256
and I can not find methods to set cache enable in qt,
should I set cache at oracle side?
If you're using oracle, you want to look at OCI_ATTR_PREFETCH_ROWS
and/or OCI_ATTR_PREFETCH_MEMORY. See
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Interest