Re: JDBC / Oracle / MS SQL Server performance anomalies

From: Omi Chandiramani <omi_at_chandiramani.org>
Date: 23 Jan 2003 23:01:33 -0800
Message-ID: <aa6b31e0.0301232301.b725846@posting.google.com>

Joseph Weinstein <joe_at_bea.com.remove.this> wrote in message news:<3E308261.4720EB94_at_bea.com.remove.this>...
> If what you want to judge is *jdbc*, you should eliminate any DBMS
> activity at all. No updates, inserts, or deletes. Just do a loop of a
> simple select.

I'm trying to judge the performance of the entire chain of components. If the performance is mostly bound to the performance of the database itself then I want to optimise that.

> them to do.. Getting the DBMSes optimized to make an insert/delete
> test fair would take some DBMS/platform work.

What kinds of things can I do to Oracle to make the inserts run faster?

> The commit() call in your code is superfluous because JDBC connections
> come in autoCommit(true) mode, so there's nothing to commit unless
> you first set autoCommit(false).

You are right. That code was in there from when auto commit was set to false and I was doing the commits manually. I've removed it from my code.

Omi Received on Fri Jan 24 2003 - 01:01:33 CST