[sqlite] Sqlite 3.x speed on insert with synchronous OFF

[Guillaume Fougnies]

Hello,

I run a simple benchmark between sqlite 3.0.3 and sqlite
2.8.15 using synchronous OFF and i get a performance decrease
of ~20%. How can it be explained? the new file format?

Here is the procedure of the test:
Table format on 3.x and 2.x:
CREATE TABLE TEST ( i INTEGER PRIMARY KEY, str text );

Test file contains the header:
PRAGMA SYNCHRONOUS=OFF;
and 90K successive blocks like this one:
BEGIN;
INSERT INTO TEST (str) values('teststr');
INSERT INTO TEST (str) values('teststr');
INSERT INTO TEST (str) values('teststr');
INSERT INTO TEST (str) values('teststr');
COMMIT;

I get:
Bench v2.x

real    1m1.955s
user    0m35.587s
sys     0m24.744s

Sync && sleep 1
Bench v3.x

real    1m17.866s
user    0m45.745s
sys     0m30.674s


Thanks in advance.
bye.
--
Guillaume FOUGNIES