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

Written By
October 04, 2009 12:58AM
October 23, 2009 12:51AM
Re: How well does full-text scale?
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.