Here is a typical statement on our

[itc1]

Here is a typical statement on our website

SELECT (title,summary,id) FROM alldata WHERE (MATCH (keywords1) AGAINST ('d4t'));

keywords1 is a fulltext, indexed field.


It was supposed to be faster than it has ended up being. The search runs really slow.

Should I build one or more tables that contain only a keyword and ID field.


For boolean searches, should some sort of JOIN statement will need to be used? Thanks in advance for any assistance.

 

[tshot]

what does EXPLAIN <ur qry stmt> have to say ?




----------------
ur feedback is a very welcome desire