Re: [sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

2010-12-17 Thread Martin Engelschalk
Hi, it was my own fault. Sorry for the noise. 3.7.4 is a lot faster. Martin Am 17.12.2010 09:30, schrieb Wiktor Adamski: > There is a lot more synchronization in 3.7.4. If you disable it new > version may be faster. > ___ > sqlite-users mailing list >

Re: [sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

2010-12-17 Thread Wiktor Adamski
There is a lot more synchronization in 3.7.4. If you disable it new version may be faster. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

2010-12-16 Thread Martin Engelschalk
Thank you for your response. I will try and find out things here first, now that I know that the new version should be faster, not slower. If i cannot determine the reason, then i will post my exact schema and statements. Martin Am 16.12.2010 13:19, schrieb Richard Hipp: > On Thu, Dec 16, 2010

Re: [sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

2010-12-16 Thread Richard Hipp
On Thu, Dec 16, 2010 at 4:01 AM, Martin Engelschalk < engelsch...@codeswift.com> wrote: > Hello List, > > i tried switching from Version 3.2.5 to 3.7.4 to make use of the new > features. > > I create a new database file and load 1.000.000 records into a single > table. > Without changing

[sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

2010-12-16 Thread Martin Engelschalk
Hello List, i tried switching from Version 3.2.5 to 3.7.4 to make use of the new features. I create a new database file and load 1.000.000 records into a single table. Without changing anything in my own code (which reads from a file and does additional processing before inserting the