lundi 20 juillet 2015

Is it a recommended practice to improve performance using PRAGMA synchronous=OFF

From this question: SQLite updating ONE record is very (relatively) slow

I see he got a big speed gain using PRAGMA synchronous=OFF.

I'm facing very slow sqlite update times (250ms) and I need to do many updates from different threads.

I have many open connections to the database from different threads. Would it be better to have just a central DataBase class wrapping the DB with locks that all threads call and use PRAGMA synchronous=OFF in order to have such speed improvement?

Aucun commentaire:

Enregistrer un commentaire