Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Simple problem...
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.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Fri Feb 28 2003 - 03:39:45 CST
-------------------------------------
![]() |
![]() |