Does adding fields to a database take up any room, even if I don't put any data in the new fields?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

Adding extra fields does take up space even if the fields are empty.

To be precise each text field takes up a minimum of 4 bytes, so if you have 10,000 records and you add 50 new, but blank, text fields, you've bumped up your database size by

4 bytes per blank text field

times

10000 fields

times

50 text fields

which is 2 megabytes.

For more information on the space taken up by the various field types, see https://www.quickbase.com/help/field_types.html.

Tags:

33302 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base