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
