Re: insert performance on NT and Solaris

"Angus Fong" <angus_fong_at_hotmail.com> wrote in message news:2db6dc80.0306081947.1116d2b9_at_posting.google.com...

>
> Windows NT 4.0, IBM netfinity, 4xP4 CPUs, 2G memeory, Raid5 only
> ~3300 rows/second

You cannot make RAID5 native in NT. You MUST be using a dedicated RAID5 controller, which will probably have a bucketfull of cache. And that means you can't compare both. Where are your redo logs? How fast are the P4 CPUs?

>
> Solaris 5.8, 420R, 4 CPUs, 4G memory, RAID 0,1 (raw devices)
> ~2700 rows/second

Are you using Sun's LVM to create the RAID0,1 devices? If so, why are you using raw? You should be using raw in your redo logs, but you do NOT need to make your data tablespace raw to get max performance.
How fast is the SUN CPU? How many 0,1 devices you using and how many db writers?

>
> Solaris 5.8, 6800, 6 processors board, 4G memory, RAID 0,1 (raw
> devices)
> ~2500 rows/second
>

Same comments as before.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam