Re: char to numeric

Lim,

Given that your original message talked about performance being critical and
there being millions of records, it would seem that speed isn't really much
of an issue after all - just in testing, you've done this conversion 10
million times and it's only added between 8 and 12 seconds to the overall
processing time... Does a few *seconds* either way make much of a difference
- I could see it maybe mattering on an interactive application, but I'm
guessing (hoping, really) that you're not processing this many records on a
regular basis in an interactive application anyway!

Rory


On 3/2/07, Lim Hock-Chai <Lim.Hock-Chai@xxxxxxxxxxxxxxx> wrote:

Oops.  Thanks for catching that.  I also notice that in the atoi method,
I declare the num as 10s 0 instead of 10i 0.  Redo and rerun and result
are below

%dec takes 8 secs.
%int takes 12 secs.
atoi takes 8 secs.