Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC / Oracle / MS SQL Server performance anomalies
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:...
> I did a similar test to you (code shown below) tab1 has a number,date and
> varchar column for the original tests, I added an NVARCHAR2 after
rereading.
> Results were
>
> using a statement 30,000 inserts = 113s, delete 4s.
> using a prepared statement 30,000 inserts 39s,delete 4s. adding the
> nvarchar2 column 30,000 inserts 41s. I didn't bother batching inserts but
> would expect a speed increase from that as well. In other words thats over
> twice as fast.
NB Having installed and got my head around the SQLServer driver the MSSQL test on this machine took 85 seconds. The machine is a celeron700 notebook with 384mb ram FWIW.
I should also have added that I don't see this benchmark as proving what you think that you are proving, and if you really are using jdbc apps to load data in a loop wouldn't sql*loader and/or dts be the way to go.
Things you could look at are
HTH
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Mon Jan 27 2003 - 10:02:45 CST