Hi,
Can someone advise on the best [fastest] way to search about
12 'text' fields from 2 tables for a keyword? It's fast from 1
table, but slows _way_ down when I add fields from the second table.
Should I:
1) Index all fields involved?
2) Get involved with multiple-column indexes
I've seen
http://www.mysql.com/doc/M/u/Multiple-column_indexes.html but am
getting a BLOB error (MySQL 3.22.32, RedHat 6.2) when trying to add
the index. The field is a text field.
Any and all advice is appreciated.
Thanks.
---------------------------------------------------------------------
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
