Re: tuning an simple insert-statement

You can't measure something withour affecting it. That being true, different systems may have different means of implementing a measurement. Bottom line is what you may be seeing is a difference in measurement techniqies rather than a difference in insert perfromance. Also, your test is faulty. You can't project that because system A took twice as long as system B to do 10 inserts that it will take twice as long to do 10,000 inserts. A may be faster than B.

As I have always said, the only meaningful test (to you) is a test with the actual data you will use under the typical load and environment in which you will be using it.

"Pascal Ziegler" <pascal.ziegler_at_bluewin.ch> wrote in message news:3f5991a9$1_at_news.swissonline.ch...
> 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
>
Received on Fri Sep 12 2003 - 10:42:16 CDT