Is there a common approach to searching within text columns that
contain fairly large blocks of text (30,000 - 65,000 characters)? Is
the recommendation, simply don't do it or is there some sort of
workaround? I suppose one can search within these columns using the
LIKE and % wildcards and risk slowing down activity to a crawl. I
suppose indexing is not going to help in this case at all. But what
does one do when it becomes more important that the search occur at
all despite the time that it might take?
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
database,sql,query,table
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php