Performance of Zoned vs Int vs Packed

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

Bob wondered:

>So are Packed Fields still faster
>performers than say Int's on this new
>hardware?

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