Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC / Oracle / MS SQL Server performance anomalies

Re: JDBC / Oracle / MS SQL Server performance anomalies

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 27 Jan 2003 16:02:45 -0000
Message-ID: <3e355829$0$245$ed9e5944@reading.news.pipex.net>


"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

  1. How much memory have you allocated to Oracle, could be too much or too little.
  2. How much redo are you generating and is the redo switching mechanism efficient - it won't be on a laptop and should be in production.
  3. You could trace the session and see what you are waiting for.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Jan 27 2003 - 10:02:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US