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