If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Why do max field lengths matter?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-12-09, 15:59
rbfree rbfree is offline
Registered User
 
Join Date: Feb 2009
Posts: 104
Why do max field lengths matter?

The practical question I'm seeking to answer is: what character length do I want to set my name fields, address fields, etc.?

But, more importantly, what I want to know is how various settings effect efficiencies and memory economy, if I can use that term. For example, given three scenarios, all with text data and no special or extended characters, how much more or less efficient would each be:

1. a maximum field length setting of 10 characters;
2. a max. field length setting of 20 characters, with NONE of the records actually containing more than 10 characters;
3. and a max. field length setting of 20 chars with all of the records actually containing 20 characters.

Compared to #1, how much more disc space and or RAM would #s 2 and 3 take?

What other considerations am I missing?

Sorry to ask all these questions, but I want to avoid later frustrations as much as possible, do to the telescoping nature of error in these systems. One error seems to go a long way.

And, I want to understand the rationale for doing things this or that way. None of these books seems to deal directly with these questions.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On