On Wed, 20 Oct 2004 19:59:38 +0100, Gary Doades <gpd(at)gpdnet(dot)co(dot)uk> 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