|
|
Posted by John Bell on 09/08/06 09:50
Hi
There can be many reasons for this to be slow not just the JDBC driver, you
may have contention for the discs with the different types of I/O and you
may have other poor configuration settings such as a poor choice of database
growth size, isolation level, or the code may not be the most optimal. You
don't say what the process is that loads this data, but look at using
something like BULK INSERT or possibly OPENROWSET instead of one insert
statement per row.
John
"dunleav1" <jmd@dunleavyenterprises.com> wrote in message
news:1157682546.451420.301260@d34g2000cwd.googlegroups.com...
>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]
|