Space/Storage

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?
 
V

Van T. Dinh

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

space/storage 1
Concerns about possible wasted storage space 2
Auto-fill data in Table 2
Lookup Yielding Key Field Values Instead of Desired Field Values 5
Help with Combo Box 4
Including an IF formula in Access 3
storage of null value 2
Expression Help 3

Top