MySQL Forums
Forum List  »  Full-Text Search

Re: How well does full-text scale?
Posted by: Rick James
Date: November 29, 2009 04:20PM

In particular, the "Query cache". You seem to have query_cache_type = ON.

How fast does this run?
select count(*) from a where match(comment) against('+pretty');
(Note the "+")
Without the "+", it will probably count all the rows, even those with zero relevance; with it, it should count only those with 'pretty' in them.

Options: ReplyQuote


Subject
Views
Written By
Posted
4366
October 04, 2009 12:58AM
2504
October 23, 2009 12:51AM
Re: How well does full-text scale?
2614
November 29, 2009 04:20PM


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.