I have a product table, which is about 3,500,000 pieces. The table has the full text in the column titled title.
The following sample request takes up to 4 seconds, which is completely unacceptable, and I'm looking at how to optimize ... ideas / tips.
Basically; which columns should be indexed, whether to pull as many columns separately or pull out all columns faster (23 in total), etc. etc.
Request example:
SELECT PRid, title, Artist, author, actors, imageURL, prodcat, lowprice,
highprice, prodcatID, description from products where
((MATCH(title) AGAINST ('+blue +top' IN BOOLEAN MODE))) order by
userrating desc limit 500
source
share