|
Posted by dunleav1 on 09/15/06 14:19
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.
Navigation:
[Reply to this message]
|