View Single Post
  #14 (permalink)  
Old 01-08-10, 12:42
MarkATrombley MarkATrombley is offline
Registered User
 
Join Date: Jul 2009
Location: Michigan
Posts: 125
The varchar datatype usually has an overhead of 4 bytes (depending on the database engine used) but only allocates the space actually used. So you can define 10 varchar columns and if they aren't used you have only "wasted" 40 bytes per row.

But for a 1 in 10 return I would break it into two tables. Especially if you are loading identities in advance of creating an account.
Reply With Quote