hello every body;
the QSqlQuery have a bad perofrmance when i use it with large tables.
I have a table with more than 31964 record and i exec the following query
SELECT field from table ORDER BY id.
when i use QSqlQuery::next it takes time to move to the next record.
and also when i use QSqlQuery::Last it takes longger time and increase the application used memory in RAM incredibly from 27 MB to 143 MB.
is there a solution or i should use the sqlite headers to do this job?
Thank you,