Hi, On Friday 26 October 2012 08:57:12 ext Xiaognag Wang wrote: > I meet a big problem need you help:1. my evnriomnent: Win7 + Qt-SDK1.2.1 + > oracle11g_home22. I compiled oci driver plugin for accessing Oracle > database from qt application.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?
Note - this is not an issue about Qt development itself, so it doesn't belong to this list. In any case, try QSqlQuery::setForwardOnly(true) on your query, then records don't need to be cached. Harald _______________________________________________ Development mailing list [email protected] http://lists.qt-project.org/mailman/listinfo/development
