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.20 Released
Super Speedy Search includes:
- Full-text index created automatically
- Standard search results page is auto optimised
- Pagination on your search results
- A shortcode and a widget to let you place the search box wherever you like
- The ability to search meta_keys too, like _sku entries for WooCommerce
- The ability to configure your widgets or shortcode to search whichever post types you wish – e.g. product,post
- Search results ordering choices – you can order by date or you can order by multiple different types of ‘relevance’. Relevance is far higher and far more accurate with a fulltext index too!
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.
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 can optionally use our search widget. It works with all post types. You’ll find the widget under Appearance->Widgets.
You can use our shortcode too:
[superspeedysearch posttypes="product,post" searchplaceholder="Search" searchbuttontext="Go"]
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.