Unsolved Why QSqlDatabase db QOCI very slow when QSqlQuery is calling next() function ?
-
@SGaist no
-
Then it might be a good idea to do so.
-
@SGaist ok
-
@SGaist how can i do it?
-
@Everton-Fonseca
HI
The bug comments says
"Resolution: This issue was resolved by set OCI_ATTR_PREFETCH_ROWS and/or OCI_ATTR_PREFETCH_MEMORY parameter with SqlDatabase::setConnectOptions() function."so use
https://doc.qt.io/qt-5/qsqldatabase.html#setConnectOptionsand try with
setConnectOptions("OCI_ATTR_PREFETCH_ROWS;OCI_ATTR_PREFETCH_MEMORY" -
@mrjj I did it
-
@Everton-Fonseca
and did it help ? -
@mrjj yet it isn't working
-
@mrjj look at example db.setConnectOptions("OCI_ATTR_PREFETCH_ROWS=1000;OCI_ATTR_PREFETCH_MEMORY=1000");
it was before open database -
@Everton-Fonseca
ok. odd. the poster said it fixed it for him.
Other poster said ODBC worked better for him.