Re: Speed difference
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 29 May 2002 22:05:27 +0100
Message-ID: <3cf54299$0$234$cc9e4d1f_at_news.dial.pipex.com>
> "Richard Kuhler" <noone_at_nowhere.com> wrote in message
> news:gGUI8.18751$R53.8606224_at_twister.socal.rr.com...
> > Doing a few simple tests, the difference is surprisingly large.
> > Although, if there's any SQL around, it's almost certainly relatively
> > insignificant. Even over 100 million iterations you'd probably one
> > shave 1 minute off the runtime...
> >
> > 10 million iterations:
> >
> > recstat IN OR
> > --------- ------- -------
> > null 23.32 17.82
> > NEW 25.89 19.03
> > INSERT 33.84 26.04
> > UPDATE 34.02 26.26
> >
> > Note: these times varried +/- 1 second across tests but OR was always
> > faster.
>
> That could be called the professional answer. I'd like to see more such
> a answers in this group.
Date: Wed, 29 May 2002 22:05:27 +0100
Message-ID: <3cf54299$0$234$cc9e4d1f_at_news.dial.pipex.com>
"Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message news:ad24ug$fab7$2_at_as201.hinet.hr...
> "Richard Kuhler" <noone_at_nowhere.com> wrote in message
> news:gGUI8.18751$R53.8606224_at_twister.socal.rr.com...
> > Doing a few simple tests, the difference is surprisingly large.
> > Although, if there's any SQL around, it's almost certainly relatively
> > insignificant. Even over 100 million iterations you'd probably one
> > shave 1 minute off the runtime...
> >
> > 10 million iterations:
> >
> > recstat IN OR
> > --------- ------- -------
> > null 23.32 17.82
> > NEW 25.89 19.03
> > INSERT 33.84 26.04
> > UPDATE 34.02 26.26
> >
> > Note: these times varried +/- 1 second across tests but OR was always
> > faster.
>
> That could be called the professional answer. I'd like to see more such
> a answers in this group.
Indeed. it does however miss out the version of the database and the optimiser goal in use.
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Wed May 29 2002 - 23:05:27 CEST