Re: char to numeric

["Rory Hewitt" <roryhewitt@xxxxxxxxx>]

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.