Just wondering: this link seems to refer to Firebird/InterBase, not
In particular, MySQL stores Blobs "in row", the text describes the
"out of row" storage of Blobs.
As a result, I don't think there is much difference in the
performance of BLOB and VARCHAR(255) in MySQL (VARCHAR is probably a
On Oct 31, 2006, at 8:06 AM, Visolve DB Team wrote:
> To BLOB or not to BLOB | Whether to store string in BLOB, or CHAR,
> or VARCHAR
> pls play the link:
> ViSolve DB Team.
> ----- Original Message ----- From: "Chris W. Parker"
> To: <mysql@stripped>
> Sent: Friday, October 27, 2006 10:35 PM
> Subject: Performance of different length/size datatypes
>> 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
>> For a db that doesn't get a lot queries is there much of a
>> difference between BLOB and VARCHAR(255)?
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?