> I cannot find any sign of BEGIN;COMMIT; . And as a result of that, Matthew, you're right, on OS (or OS + file system) where fsync() doesn't do physical write test getting huge boost in performance. Just take the second test: 12,500 transactions in 771.13 seconds giving about 16 transactions per second which is reasonable and explainable. Any faster performance is questionable, especially the order of magnitude faster...
Pavel On Tue, Sep 29, 2009 at 5:17 PM, Simon Slavin <slav...@hearsay.demon.co.uk> wrote: > > On 29 Sep 2009, at 8:57pm, Matthew Tippett wrote: > >> In particular >> http://www.phoronix.com/scan.php?page=article&item=linux_2631_kvm&num=3 >> http://www.phoronix.com/scan.php?page=article&item=freebsd8_ubuntu910&num=7 >> >> In both of these cases, there are configurations where there is an >> order >> of magnitude difference between the performance of the systems. >> >> I would like to confirm my expectation that SQLite will by default >> always do synchronous file operations. It seems that in the Ubuntu >> guest on KVM Ubuntu host and the FreeBSD-8.0-RC1 benchmarks, it would >> appears that the kernel and filesystem are not honoring the request >> for >> synchronous fileIO. >> >> Is my assertion sane? If some SQLite domain experts could look at the >> results and temper to what performance numbers "sound right" for >> SQLite >> it would be appreciated. > > To save everyone else tracking it down, the SQL test in this case > consists of > > CREATE TABLE pts1 ('I' SMALLINT NOT NULL, 'DT' TIMESTAMP NOT NULL > DEFAULT CURRENT_TIMESTAMP, 'F1' VARCHAR(4) NOT NULL, 'F2' VARCHAR(16) > NOT NULL);\ > > and then running 2500 lines like these: > > INSERT INTO 'pts1' ('I', 'DT', 'F1', 'F2') VALUES ('1', > CURRENT_TIMESTAMP, '6758', '9844343722998287'); > INSERT INTO 'pts1' ('I', 'DT', 'F1', 'F2') VALUES ('2', > CURRENT_TIMESTAMP, '3733', '8925952369645997'); > INSERT INTO 'pts1' ('I', 'DT', 'F1', 'F2') VALUES ('3', > CURRENT_TIMESTAMP, '5636', '8366445547934654'); > INSERT INTO 'pts1' ('I', 'DT', 'F1', 'F2') VALUES ('4', > CURRENT_TIMESTAMP, '5626', '1439954363252147'); > > I cannot find any sign of BEGIN;COMMIT; . > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users