On Wed, 20 Oct 2004 19:59:38 +0100, Gary Doades <[EMAIL PROTECTED]> wrote:
> Hmm, that seems a bit slow. How big are the rows you are inserting? Have you checked
> the cpu and IO usage during the inserts? You will need to do some kind of cpu/IO
> monitoring to determine where the bottleneck is.
The bulk inserts don't take full cpu. Between 40% and 80%. On the
other hand, a select will take 99% cpu.
>
> What hardware is this on? Sorry if you specified it earlier, I can't seem to find
> mention of
> it.
It's on a P4 HT with 1,128 megs ram.
-Josh
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
