Subject Re: High CPU usage AFTER bulk insert completed
Author Aage Johansen
Kenneth Foo wrote:
> ...
> Machine spec:
> Win2k,
> Forced Writes=false.
> 320MB RAM
> Celeron 450MHz (Oh yeah, machine's that old :-)


ForceWrites=false may speed things up, but you should be using
ForceWrites=true on Windows. It seems that database pages are flushed
rather infrequently (only at disconnects?) with ForceWrites=false.


Regards,
Aage J.