On 25 Sep 2002, at 16:28, Brent Baisley wrote:
> Your biggest speed benefit can actually be attained by avoiding varchar
> and text fields altogether, use char(). This will cause each record to
> be exactly the same length, which will allow MySQL to "jump" to spot in
> the file quicker. It's l
It's probably faster to retrieve from a varchar field than a mediumtext
field, but any benefit is completely erased by the need to perform an
"OR" query to search in both fields.
Your biggest speed benefit can actually be attained by avoiding varchar
and text fields altogether, use char(). Thi
Hi All,
I've built a survey application in MySQL that allows people to enter
free-form comments. In processing the input, if the comments string is less
than 256 characters long, I save it to a varchar column; if longer, I use a
mediumtext.
This works fine, but I'm wondering if I'm getting any r
