Hi Everyone!
I've got two seperate tables that I would like to query using a MATCH ..
AGAINST() syntax. If I run the query individually on one table, the
speed of the returned results is great! Very fast, indeed. However,
when I try and use the following statement for querying both tables at
the same time, it is painfully slow. Too slow to use in a production
environment.
Any help speeding this up would be greatly appreciated.
Thanks in advance!
Paul
The super slow query is....
SELECT DISTINCT * from tA, tB WHERE MATCH tA.aName AGAINST ('name') ||
MATCH tB.bName AGAINST ('name');
The fast queries are....
SELECT DISTINCT * from tAWHERE MATCH tA.aName AGAINST ('name');
SELECT DISTINCT * from tBWHERE MATCH tB.bName AGAINST ('name');
---------------------------------------------------------------------
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
