Re: Speed difference

From: Stjepan Brbot <stjepan.brbot_at_zg.hinet.hr>
Date: Wed, 29 May 2002 09:08:27 +0200
Message-ID: <ad24ug$fab7$2_at_as201.hinet.hr>


[Quoted] "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.

--

Stjepan Brbot
Received on Wed May 29 2002 - 09:08:27 CEST

Original text of this message