|
Posted by dunleav1 on 09/08/06 02:29
I have a process that I loads about 1000000 records into various tables
via jdbc.
With Sql server it takes about 35 minutes. If I use jtds or microsoft's
jdbc driver.
With Oracle it takes 5 minutes.
I have Oracle and Sql server configured on the same server. I stop the
other db vendor services when I run the process.Sql server is in simple
recovery mode and oracle in noarchivelog mode. They share the same raid
array configuration - raid 1/0.
Can Oracle's jdbc driver be that much better than Microsoft?
Navigation:
[Reply to this message]
|