Chris, it should be noted that a BLOB is binary data, not character
data like VARCHAR. BLOBs will act differently in terms of
case-sensitivity for example. The TEXT data type might be more what
you're looking for.
See http://dev.mysql.com/doc/refman/5.0/en/blob.html
for some more info on BLOB and TEXT.
Hard to say what difference in performance would be like. If database
isn't used much, does it matter much?
Dan
On 10/27/06, Chris W. Parker <cpar...@swatgear.com> wrote:
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd just cut to the chase and ask...
For a db that doesn't get a lot queries is there much of a performance
difference between BLOB and VARCHAR(255)?
4 messages in com.mysql.lists.mysqlRe: Performance of different length/s...