What data type to use for variable lenght data for performance
- by jiewmeng
what data type shld i use for data that can be very short, eg. html link (think twitter), or very long eg. html blog post (think wordpress)
i am thinking if i use varchar(4000), it maybe too short for a html formated blog entry? but if i use text, it will take up more space and is less efficient?