MySQL Forums
Forum List  »  Performance

Re: Help in FullText Search Performance
Posted by: Peter Brawley
Date: July 07, 2022 03:10PM

In 16GB RAM and a 3m-row table with an ft index on a varchar column, I get a 200-row result from a query like yours in about 3 secs. I can't think of a reason to expect much faster results from FT.

Care to post the result of Explain Analyze on the query?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Help in FullText Search Performance
13
July 07, 2022 03:10PM


Sorry, only registered users may post in this forum.

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.