Space/Storage

  • Thread starter Thread starter J. Keenan
  • Start date Start date
J

J. Keenan

assume I have a table with a bunch of recorsd in it ... I
have say 200 columns in the table. All fields/columns
are null (as in vbNull)... except the 1st column which
has an ID in it... Does this take up significantly less
storage than if there was data filled in most of columns?
 
Yes since JET does not reserve space for empty Fields.

OTOH, you should be aware of:

1. The Record "length" is only 2K (4K with JET 4 due to Unicode???) and if
the values in the 200 Fields (excluding Memo & OLE Fields which are stored
separately) require more than 2K bytes, you won't be able to store / update
the Record.

2. 200 Fields in a Table is exceedingly high. For properly-normalised
Table Structure, the number of Fields in a Table should rarely exceed 50
(the max. I used is 36 and this is already slightly denormalised).

Have you checked your Table Structure for proper nomalisation?
 
Back
Top