Slow performance

[DEVA RAJ]

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.