Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-10-01 Thread Matthew Tippett
Yes. It was sent from an unsubscribed address, queued in the moderator who looks like they just cleared the queue. Regards... Matthew On 10/1/09, Pavel Ivanov wrote: >> We solved this yesterday, right ? Is anyone else seeing this a second >> time ? > > Yes. Though date of the second letter co

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-10-01 Thread D. Richard Hipp
On Oct 1, 2009, at 1:35 PM, Pavel Ivanov wrote: >> We solved this yesterday, right ? Is anyone else seeing this a >> second >> time ? > > Yes. Though date of the second letter correctly shows that it was sent > 2 days ago I've received it just minutes ago. When a non-subscriber sends an email

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-10-01 Thread Pavel Ivanov
> We solved this yesterday, right ? Is anyone else seeing this a second > time ? Yes. Though date of the second letter correctly shows that it was sent 2 days ago I've received it just minutes ago. Pavel On Thu, Oct 1, 2009 at 1:25 PM, Simon Slavin wrote: > > On 29 Sep 2009, at 8:37pm, Tippett

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-10-01 Thread Simon Slavin
On 29 Sep 2009, at 8:37pm, Tippett, Matthew wrote: > I would like to highlight the following SQLite benchmark results > posted > by Phoronix via Phoronix Test Suite (http://www.phoronix-test-suite.com/ > ) We solved this yesterday, right ? Is anyone else seeing this a second time ? Simon.

[sqlite] SQLite behaviour on FreeBSD and KVM

2009-10-01 Thread Tippett, Matthew
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&it

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-09-29 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Matthew Tippett wrote: > I would like to highlight the following SQLite benchmark results posted > by Phoronix via Phoronix Test Suite (http://www.phoronix-test-suite.com/) An earlier test showed massive differences for Linux filesystems but those res

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-09-29 Thread Simon Slavin
On 29 Sep 2009, at 10:29pm, Matthew Tippett wrote: > If there is anyone who is interested in assisting in improving the > quality/value/functional interest of the benchmarks, then please > advise. In SQLite, when you know you are making many changes and don't need to consult the data until you

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-09-29 Thread Matthew Tippett
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 w

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-09-29 Thread Pavel Ivanov
> 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

Re: [sqlite] SQLite behaviour on FreeBSD and KVM

2009-09-29 Thread Simon Slavin
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 >

[sqlite] SQLite behaviour on FreeBSD and KVM

2009-09-29 Thread Matthew Tippett
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=freeb