>>>>
The slow queries are those like...
SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
<<<<
WHERE field like '%text%' <-- this will not use an index. Read the manual
about fulltext. It may or may meet your needs. It works pretty good. If the
text is a word you could also build a word index table. Check the list
archives. If you are scanning for something like '<SCRIPT type=' in a field,
then you will have little luck. So the answer depends on what you are trying
to do (as always).
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
mysql
---------------------------------------------------------------------
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