Re: Storing Numeric Values in the Database

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Joe,

My vote is integers for numbers with zero decimal places, otherwise packed.

Couldn't tell you the last time I used DSPPFM to look at a record.  I
used SQL or DBU when I need to look at data.

Charles

On Fri, Sep 2, 2011 at 8:01 AM, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx> wrote:
> Generally speaking, what is the current wisdom about storing numeric
> data in the database?  Do folks still prefer packed representation for
> data with decimal positions?  Zoned is a little easier on the eyes when
> looking at a raw record, but it takes a few more bytes especially as the
> fields get larger.  And as far as I know RPG still likes to convert
> things to packed when it reads a file unless you tell it not to.  That
> being the case is there still a performance issue these days?
>
> We like zoned fields here, but I'm trying to address the issue from a
> thorough technical standpoint.  If you're trying to be as lean as
> possible, you could argue that integers should be stored in binary,
> although that has its own issues.  Heck, an argument could be made that
> you should store all data as integers with implied digits and decimal
> positions.
>
> What say you all?
>
> Joe
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.