How to handle huge data with QSqlQueryModel?
-
We have a QSqlQueryModel which loads a huge chunk of data. When its size of loaded data reaches to about 1.5 GB, the program crashes. How can we handle this situation? Can we catch an exception or limit the amount of data that QSqlQueryModel loads?
-
SQL type? mysql Db2 or Sqlite3 Oracle ...?
I have seen Sqlite3 handle & search data inside 12Gb .. and load dump from file in very fast time.. play db optimisation...