PDA

View Full Version : QtSql cursor read, posrgeSql



lk
18th February 2013, 17:40
Hi,

While reviewing the Sql drivers code, it seems that the postgreSql driver is not using cursors

Is it possible to store in memory only part of a select result and traverse it before fetching the next set of rows using the PostgreSql driver?

From the code it seems that the driver reads using the inherited QSqlResult setAt method so it inherits a generic results storing way in which the entire results are read first,
and then you can emulate reading part of them by changing the index, but the memory will contain all result rows

Is that correct? Is there a way to read part of the results rows to memory for PostgreSql?

Thanks
lk