I have a database with a description field. It is an NVarChar datatype. Out of 7000 records, only 100 have a description length over 400 characters. The highest is around 2000. My question is this. Is it more efficient to increase the maximum length for the field to 2000, or would it be better to set the max length to 400 and have another table for the longer entries? I would appreciate any input on this subject.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What is more efficient?
- Thread starter roblasch
- Start date
If you only have 7000 records and there is going to be no signinficant increase then I would say it's not an issue worth worrying about.
What ever you change the difference won't be noticeable so go with whatever is easiest to maintain.
Rick.
What ever you change the difference won't be noticeable so go with whatever is easiest to maintain.
Rick.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question