Split of table or not?

According to MySQL docs, if a table contains text or blob field, then
table join using temp table must be using disk.

So if I have a rather big table contains text fields, should always
split the table so all text fields is on another table, so that my new
"big table" with text fields removed can join with other tables
without using too disk temp table?

Thanks.

Roy M wrote:
> According to MySQL docs, if a table contains text or blob field, then
> table join using temp table must be using disk.
>
> So if I have a rather big table contains text fields, should always
> split the table so all text fields is on another table, so that my new
> "big table" with text fields removed can join with other tables
> without using too disk temp table?
>
> Thanks.
>

If you aren't using the text or blob column in most of your queries,
then yes.

I store a lot of images in the database. When doing it, I always have a
separate table for the blob column because there are many queries where
I just get information on the item but not the image. It helps keep
system utilization down.

But if you're almost always using the text/blob column anyway, putting
it in a separate table won't help much (and may slow things down slightly).


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================