Quality search results have long been a problem with WordPress and WooCommerce. Not only are the traditional search techniques inaccurate, they’re slow too!
Super Speedy Search solves this using multiple full-text indexes which improve accuracy and transform speed.
It’s so fast that we’ve made it search as you type. So, users start typing ‘Harry Potter’ and before their very eyes, your shop archive updates with all of your Harry Potter products.
Technical Details – Full-text Index
The default plugins, and most premium plugins use the LIKE operator to search your database. This is slow because it prevents the use of any indexes. It’s also inaccurate, because for the LIKE operator to get a successful match it has to match identically what is in your database.
Full-text indexes are different – they provide something called stemming which means a search for ‘childrens clothes’ will match ‘child clothes’, ‘clothes for children’ and other derivatives. Stemming means words in your database are reduced to their language root, their derivative. Because of this, accuracy is increased and your users don’t have to type exactly what’s stored in your descriptions in order to find products.
Full-text indexes also provide a relevance score. If you’ve searched on Amazon before, you know that they’re good at showing you relevant results, but it is often difficult to find relevant results with other WordPress search plugins. Super Speedy Search uses multiple full-text indexes to search across post_title, post_content and the values in wp_postmeta.
You can read a little more about this here on our roundup of plugins installed on our FoundThru demo site.
Version 1.0 Released
Super Speedy Search is now out of beta and includes:
- Full-text index created automatically
- Standard search results page is auto optimised
- Ajax WooCommerce search widget which updates the archive as you type
- Pagination now works fully, i.e. this is ready for production use
Demo of Super Speedy Search
We have a demo site containing 820,000+ products where you can try out Super Speedy Search for yourself.
Visit https://foundthru.com/ and you’ll find the Search Widget in the sidebar. Note: From the FoundThru home page, the default behaviour is to open the search results using the default search results page. Once you have a WooCommerce product archive on the page, THEN Super Speedy Search will update the search results as you type using Ajax.
Upload the plugin files and activate it. The plugin will build the full-text index against wp_posts (title and description).
Your normal search results pages are now fully optimised – e.g. /?s=harry+potter&post-type=product
You may optionally use our Ajax search widget instead of using the search results page. This Ajax search widget works with WooCommerce pages only and will update your WooCommerce product archive (list of visible products) as you type into the widget. If there is no archive on the page, the widget reverts to the default behaviour of using the normal /?s=harry+potter search results page.
How does it work?
The Super Speedy Search plugin spots any free-text searches against wp_posts and replaces the default LIKE operator with a faster and more accurate MATCH operator. So if you already have a search results page, this will be optimised immediately.
There is also a new widget provided which rather than having a separate search results page, replaces your current archive search results as you type. It’s very fast as you can see in the video below which is on my reference WooCommerce affiliate site with 820,000+ products and it’s only a $40 per month Digital Ocean server.
Upcoming Feature and/or Request a Feature
You can view and discuss the upcoming features on our features page. You can also suggest new features if there’s more you’d like to see that we’re not already planning.
Super Speedy Search Support
We are building our FAQ as questions come in, so if you have a support question about Super Speedy Search please do ask! You can submit a ticket here.