There's also the obvious question of, what SQLite version are you using on each OS? -- Darren Duncan
On 2015-10-17 12:57 PM, Simon Slavin wrote: > > On 17 Oct 2015, at 8:53pm, Lucas Ratusznei Fonseca <lucas.ratusznei at > gmail.com> wrote: > >> 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. > > What extension does your database file have ? Is it something commonly used > like .db or .123 ? > > Try renaming the database file to have a weird extension like .k7x or .6p2 . > Tell us whether it helps. > > Also try turning off (temporarily, of course) any anti-virus package you have > running. > > Simon.