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

Home -> Community -> Usenet -> c.d.o.server -> Simple problem...

Simple problem...

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 28 Feb 2003 09:39:45 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7035CB2D6@lnewton.leeds.lfs.co.uk>


Hi Daniel,

ok, I changed it and tried out both versions.

Using round(x,0) takes about 11.07 seconds to check 1,000,000 numbers. Using mod(x,1) takes 14.04 second to do the same 1,000,000 numbers.

Averaged over 5 runs discarding first results.

Seems that MOD is a tad slower.

Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com

-------------------------------------
Received on Fri Feb 28 2003 - 03:39:45 CST

Original text of this message

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