On Sat, Feb 11, 2006 at 09:21:43PM +0100, Jochem van Dieten wrote: > On 2/11/06, Andrej Ricnik-Bay wrote: > > Has anyone here seen this one before? Do the values > > appear realistic? > > > > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison > > The values appear to originate from an intrsinsically flawed test setup. > > Just take the first test. The database has to do 1000 commits. That > means 1000 I/O operations. There is no way that a 7200 RPM disk can do > that in the time that that test says it took. It is reasonable to say > that a disk can do 1 I/O operation per rotation, which means that any > test result below 9 seconds is untrustworthy. > > Jochem > Jochem,
If the heads of the disk are in the right location, you could easily do more than 1 commit per disk revolution so the values over 2 seconds could actually be valid. 9 seconds would be worst case of 1 commit per revolution. Ken ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
