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