Re: Performance of Zoned vs Int vs Packed

Hey... you forgot floating point... :)


On Wed, 6 Feb 2002, Buck Calabro wrote:
>
> Anecdotal evidence tells me that Int is the fastest but int's don't work for
> many business transactions that involve money (decimals) although Binary
> does.
>
> To test my assumptions, I ran some loops with no optimisation.  50k
> iterations, 500k and 5 million.  Times are in seconds.
>
> Definition  50k  500k  5m
> 10s 0        0     3   32
> 10p 0        1     2   33
> 10i 0        0     0    1
>  9b 0        0     4   59
>  9s 0        0     3   29
>  9p 0        0     2   30
>
> I won't bother with my machine/memory, etc. because all I'm interested in is
> the relative difference, not whether an 820 is faster than a P02.  Here's
> sample code:
>
> d LIMIT           c                   const(5000000)
> d start           s               t
> d stop            s               t
> d diff            s             10i 0
>
> d numZ10          s             10s 0
> d numP10          s             10p 0
> d numI10          s             10i 0
> d numB09          s              9b 0
> d numZ09          s              9s 0
> d numP09          s              9p 0
>
> c                   eval      numZ10 = LIMIT
> c                   time                    start
> c                   do        numZ10
> c                   enddo
> c                   time                    stop
> c     stop          subdur    start         diff:*s
> c     diff          dsply
>
> One loop for each "num" D-spec above...
>   --buck