$query = mysql_query("SELECT * FROM lit_entries
LEFT JOIN lit_keywords ON (lit_keywords.id=lit_entries.Reference_Identifier) WHERE MATCH(Periodical_Full,Primary_Title,Secondary_Title,Tertiary_Title,Primary_Authors,Secondary_Authors,Tertiary_Authors,Quaternary_Authors,Quinary_Authors,Abstract,[COLOR="Red"]data[/COLOR])
AGAINST ('$_POST[textitems]' IN BOOLEAN MODE) group by Reference_Identifier
order by Publication_Year DESC,Primary_Authors ASC") or die(mysql_error());
}
Here is the problem. All of these fields have indexes...the query is fast when I don't include the data field from the second table. When I do it slow down it a CRAWL. is there a special way to do a FULLTEXT search on a JOIN?
Primary_Authors FULLTEXT
Primary_Authors
Primary_Title
Periodical_Full
Abstract
Secondary_Authors
Secondary_Title
Tertiary_Authors
Quaternary_Authors
Quinary_Authors
Tertiary_Title
data FULLTEXT
