QSqlQueryModel and QSqlQuery methods taking more execution time with QSQLCIPHER plugins

[Kuldip Somwanshi]

I am using QSQLCIPHER plugin for encryption for the database and previously I was using sqlite3 plugin, I Observed that the query execution with qsqlcipher plugin is taking much more time when working with QSqlQueryModel and QSqlQuery methods. So not getting what exactly happening sqlcipher will add only 10 to 15 percent extra overhead in execution time. but with QSqlQueryModelmethods (setQuery, prepare, exec) is very much

[SGaist]

Hi,

You should add more information:

• SQLCipher version
• Qt version
• OS
• debug vs release ?

[Kuldip Somwanshi]

I am using QT version 5.12.9
SQLCipher version 3.32.2
OS - windows 10
build type - debug

[SGaist]

Did you benchmark the release build ? Debug can have a big performance impact.

[Kuldip Somwanshi]

Yes I did benchmark on release build too. but still there it is taking so much time for execution. especially QSqlQueryModel::setQuery method and sqlQuery::exec method is taking so much time.

[SGaist]

Did you check the recommendations of the SQLCipher ?

[Kuldip Somwanshi]

Yes I checked that too and my code is optimized as sqlcipher recommendations

[SGaist]

Did you check the performance if you use the library directly ?

[Kuldip Somwanshi]

I have worked with the qsqlcipher plugins well and gone through with the qsqlcipher plugin code and I puted some print statement in the plugin code itself then observed that the fetchNext function taking is more time, Please look into it