H.J. Sanders wrote:
> X206 IBM X226
> ---------------------- -------------------
> processor Pentium 4 3.2
> Ghz Xeon 3.0 Ghz
> main memory 1.25
> GB 4 GB
> discs 2 x SCSI RAID1 10000RPM
> 1 x ATA 7200 RPM
Noting that the SCSI discs are on the *slower* machine.
> Time at X206 Time at X226
> -------------------- ------------------
> insert record (1 to 10000) 6 sec. 41 sec.
> select record (1 to 10000) 4 4
> delete record (1 to 10000) 6 41
>
>
> This is ofcourse a totally unexpected results (you should think off the
> opposite).
Your ATA disk is lying about disk caching being turned off. Assuming
each insert is in a separate transaction, then it's not going to do
10,000 / 6 = 1667 transactions/sec - that's faster than it's rotational
speed.
> Funny is that the select time is the same for both machines.
Because you're limited by the speed to read from RAM.
By the way - these sort of tests are pretty much meaningless in any
practical terms.
--
Richard Huxton
Archonet Ltd