Re: Date performance

[dhandy@xxxxxxxxxxx (Douglas Handy)]

Brigitte,

>Another drawback of the Date-field story is the disk occupation.

>PS: In test (V3R7) I created a file with the systemvalue date separator (for
>date displaying) on the normal  '/'.
>Believe it or not but that sign was put in every datefield in the physical
>file, converting 4bytes packed dec. to 10 bytes  ??

Although one would easily surmise that physical files take 10 bytes of
disk per DDS "L" type field, this is not actually the case.  In terms
of storage, both date and time fields take 4 bytes each -- regardless
of date/time format.  The system performs all the conversions for you
to get the data to/from the date/time format requested.

So using any L-type date really only occupies 4 bytes of data each --
the same as your current 7,0 packed fields (plus it carries the
century info at the same time).

HTH,
Doug
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---