Just wondering: this link seems to refer to Firebird/InterBase, not
MySQL.
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
tick faster).
Regards,
Paul
On Oct 31, 2006, at 8:06 AM, Visolve DB Team wrote:
> Hi,
>
> To BLOB or not to BLOB | Whether to store string in BLOB, or CHAR,
> or VARCHAR
> pls play the link:
> http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm
>
> Thanks
> ViSolve DB Team.
> ----- Original Message ----- From: "Chris W. Parker"
> <cparker@stripped>
> To: <mysql@stripped>
> Sent: Friday, October 27, 2006 10:35 PM
> Subject: Performance of different length/size datatypes
>
>
>> 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)?
>>
>>
>>
>> Thanks,
>> Chris.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?
>> unsub=mysql_support@stripped
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=paul.mccullagh@stripped
>
