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

Home -> Community -> Usenet -> c.d.o.misc -> Re: tuning an simple insert-statement

Re: tuning an simple insert-statement

From: andrewst <member14183_at_dbforums.com>
Date: Sat, 06 Sep 2003 11:08:06 -0400
Message-ID: <3338580.1062860886@dbforums.com>

Originally posted by Pascal Ziegler

> my task is to compare the performance of a function in cache with a

> similar implementation in oracle. the insert-statements in the
> function

> are dynamic (not hard-coded), but for my measurement I used a
> hard-coded

> statement. cache needs about 70 microseconds to insert the values...

> oracle is about 3-4 times slower. i know that this measurement
> can't be

> very accurate and there are a lot of other things that influence my

> measurement. but the point is, (after severeal measurements)
> that oracle

> is always slower. i am a oracle-rookie, i have to do this
> comparison for

> my degree disertation (university of zurich). now i'm looking for

> possibilities to improve the performance of oracle. i'm not
> looking for

> the final solution... but just points where i can start to tune
> my oracle.

>

> what else:

> - there are no triggers firing.

> - i havent traced my function... but I thought that my statement
> is not

> that complex that i can find the problem with tracing... (?)

>

> by the way: is this a right presumption: I can't improve the
> performance

> of an insert-statement, when i build a data-cartridge (with an own

> index-structure). i think with an index it even gets slower...?

>

> thank you for the help! :-)

>

> - pascal

>

>

> Ron Reidy wrote:

> > What is slow? How long does it take? Are you performing 100s
> of 1000s

> > of these hard-coded things? Are there triggers firing? have
> you traced

> > a session and determined what waits if any are occuring?

> >

> > What expectations do you have for speed?

> >

> > Pascal Ziegler wrote:

> >

> >> hi,

> >> i have to insert several values with a simple insert-
> statement.

> >> e.g.

> >> INSERT INTO xy VALUES (1, 2, 3, 4); -- really simple ;-)

> >> (the table has just a primary-key index!!)

> >> i did this with oracle 9i and cache from intersystem!
> cache

> >> was about 5 times faster than oracle!! is this just

> >> the way it is or can i improve the performance of
> oracle!??

> >> and how?

> >> thanks

> >> - pascal

> >

> >

Use bind variables

--
Posted via http://dbforums.com
Received on Sat Sep 06 2003 - 10:08:06 CDT

Original text of this message

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