MySQL Forums
Forum List  »  Full-Text Search

Slow performance
Posted by: DEVA RAJ
Date: August 28, 2009 06:38AM

Hi,

I used following query. It took 22 seconds for complete.

SELECT id FROM table1
WHERE MATCH(column1,column2) AGAINST('+syste* +meth*' IN BOOLEAN MODE);

But I modified this query into two like below and both took 3 seconds totaly to complete.

SELECT id FROM table1
WHERE
MATCH(column1,column2) AGAINST('+syste*' IN BOOLEAN MODE);

SELECT id FROM table1
WHERE
MATCH(column1,column2) AGAINST('+meth*' IN BOOLEAN MODE);


From the above, I understood that if I use single word in AGAINST clause, it works fast. Whereas if I add more key words, it works very slow.

Please guide me how to increase performance with more than one words in AGAINST clause.

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow performance
3699
August 28, 2009 06:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.