If there is anyone who is interested in assisting in improving the quality/value/functional interest of the benchmarks, then please advise.
PTS can handle direct numerical, average or gemetric means at individual test case or aggregate test suites. Regards... Matthew On 9/29/09, 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 > -- Sent from my mobile device _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users