Hi all, I am using sqlite for years with my software on Windows XP, no more than 1 or 2 milliseconds per transaction (insert), so speed has never been a concern. Until now. I had to migrate my system to Windows Seven recently, I am still doing tests and stuff. It happens that some processes became very slow. Digging in the source code, I found out that Sqlite transactions now take about 120 milliseconds, which is unacceptable for me. I tried to modify journaling and synchronization, I achieved great time reduction but not enough. Besides, I must not change journaling and sync because of integrity. I need it to work well with the defaults. Is there something I am missing?
Best regards
