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