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"
<[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]