Full text index

Super Speedy Search provides the option to search through posts using a fulltext index. This is highly recommended since it’s both faster and produces more relevant results than using the default LIKE operator.

Choose the fulltext index fields

Choose which fields to search, then hit ‘Yes’.

Then scroll down to the bottom and save your settings.

Create the fulltext index

After you have saved your settings, at the top of the screen there will be an admin notice containing a button ‘Create fulltext index on posts’. This button will actually create the fulltext index – until the index is created, your searches will continue to use the slow LIKE operator.

With large sites, you should choose a quiet time to build this index. You should ensure you have the latest version of MySQL too – InnoDB tables are faster than MyISAM for WordPress websites (because they have row-locking rather than just table-locking) and InnoDB fulltext indexes only got added in MySQL 5.6. Hopefully you’re on MySQL 8 or MariaDB or PerconaDB and if so then you will definitely be able to create the index.

When you’re ready to create the fulltext index, click the button. It will make the DB call to create the index. On larger sites, the ajax call may time out but if you wait long enough the index will still get created.

If you are waiting on the index to be created and you wish to check if Super Speedy Search is in operation yet, you can check out our FAQ article How to check if Super Speedy Search is Working.

 

Did this article answer your question?

Leave a Reply

Your email address will not be published. Required fields are marked *


We use cookies

We use cookies for various things on our site, including our on-site chat bubble (if you use it), our comment forms (if you use them) and for session handling (if you log in).

Other than that, we use cookies to identify where traffic came from to help us understand which traffic turns into sales, we use a cookie for Google Analytics traffic analysis and we use a cookie to customise adverts for our own products we think you'll be interested in.

You can read more detail in our privacy policy page. Please click 'Accept' or 'Decline' to continue.