QSqlQuery next大数据崩溃

QSqlQuery的查询结果遍历时需要缓存数据用于seek操作，大数据时会出现数据访问越界崩溃。

setForwardOnly(true)后可以禁用缓存。setForwardOnly(true) 要在执行exec()之前调用。

void QSqlQuery::setForwardOnly(bool forward)

Sets forward only mode to forward. If forward is true, only next() and seek() with positive values, are allowed for navigating the results.

Forward only mode can be (depending on the driver) more memory efficient since results do not need to be cached. It will also improve performance on some databases. For this to be true, you must call setForwardOnly() before the query is prepared or executed. Note that the constructor that takes a query and a database may execute the query.

Forward only mode is off by default.

Setting forward only to false is a suggestion to the database engine, which has the final say on whether a result set is forward only or scrollable. isForwardOnly() will always return the correct status of the result set.

Note: Calling setForwardOnly after execution of the query will result in unexpected results at best, and crashes at worst.

Note: To make sure the forward-only query completed successfully, the application should check lastError() for an error not only after executing the query, but also after navigating the query results.

Warning: PostgreSQL: While navigating the query results in forward-only mode, do not execute any other SQL command on the same database connection. This will cause the query results to be lost.