Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC / Oracle / MS SQL Server performance anomalies
run faster
use bind variables (prepared statements)
commit at the end NOT on every statement. That will slow things
down(autocommit)
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Omi Chandiramani" <omi_at_chandiramani.org> wrote in message news:aa6b31e0.0301232301.b725846_at_posting.google.com...Received on Fri Jan 24 2003 - 06:37:38 CST
> 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