Re: sql server i/o bottle neck ?


dunleav1 wrote:
It's hard to explain the I/O disparity without knowing the details of your
job. My first guess is that you might be committing each SQL Server insert
(default is autocommit) but not each Oracle insert (default is implicit
transactions on). This would require SQL Sever to perform many more
transaction log writes.
Can you explain this paragraph a little more. I'm not a java guy.
Thanks for your help.

Looking at the java code- autocommit is set to false using the
setAutoCommit class.

.

Relevant Pages