Would turning autocommit off help?
Vivek Khera wrote:
>>>>>>"FW" == Florian Weimer <fw(at)deneb(dot)enyo(dot)de> writes:
>
>
> FW> After increasing the number of checkpoint segments and the shared-memory
> FW> buffers, performance is back to the expected levels. It might even be a
> FW> bit faster.
>
> If you've got the time, could you try also doing the full bulk insert
> test with the checkpoint log files on another physical disk? See if
> that's any faster.
>
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg(at)Cranel(dot)com
Cranel. Technology. Integrity. Focus.