Hi, I would like to highlight the following SQLite benchmark results posted by Phoronix via Phoronix Test Suite (http://www.phoronix-test-suite.com/)
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. Regards, Matthew _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users