|
|
Posted by dunleav1 on 09/12/06 19:34
John Bell wrote:
> 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
I've tried four different vendor jdbc drivers - ms, jtds, jnetdirect,
jturbo.
jtds is the fastest.
I have a raid 1/0 disk array - the entire db is loaded on the array
along with the os. Identical configuration as Oracle. The average disk
queue is 30% for sqlserver regardless fo driver. Network bandwidth is
at 15% on the nic.
The database is presized so there is no growoth occuring on the log or
application db, or tempdb.
The process that loads the data is a process written in java - it
basically does inserts as batch - as a stored procedure.
>
> "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]
|