Re: [sqlite] SQLITE_NO_SYNC, PRAGMA synchronous or asynchronous io module?

Pavel, I have set up a test program without QtSql and could not reproduce any of the performance degradations. So the problem has nothing to do with sqlite. Sorry for the noise. Cheers, Benjamin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLITE_NO_SYNC, PRAGMA synchronous or asynchronous io module?

Hi Pavel, thanks for helping me out! >> Is this intended behaviour? How does the pragma/async io module fit in, >> then? >> > I believe you've got something wrong in your tests. Because with > asynchronous module (if you indeed used its VFS when created your > connections) no actual disk I/

[sqlite] SQLITE_NO_SYNC, PRAGMA synchronous or asynchronous io module?

Hello, I'm using sqlite in a speed critical application. Data integrity after crashes is not very important as the database can be recreated from scratch in that case. In my tests, the writing of data with insert commands seemed very slow, despite being wrapped in a transaction. I have tried