Do I Need Super Speedy Search?
Not every WordPress site needs a dedicated search plugin. Before you install anything, it helps to know exactly what problem Super Speedy Search solves, what symptoms tell you that you have that problem, and where the honest cut-off is. This page is here to help you decide, not to talk you into it.
The problem it solves
Out of the box, WordPress search runs a LIKE '%term%' query against your posts. That pattern cannot use a normal database index, so MySQL has to read every row in the table (a “table scan”) to find matches. On a small blog that is invisible. On a large catalogue or content library it becomes a serious drag: search gets slower and slower as the site grows, it can hammer the database, and on very large sites it can time out entirely. On top of the speed problem, default search only looks at the title and content of a single post type, and it ranks results crudely, so relevance is often poor.
Super Speedy Search takes a different approach. It builds and maintains its own denormalised, fulltext-indexed side table and swaps the slow LIKE operator for MySQL’s MATCH ... AGAINST fulltext operator. Because that uses a real index, search stays fast at any catalogue size, and the fulltext engine gives you relevance ranking, weighting, misspelling tolerance and synonyms for free. It also adds an instant, as-you-type AJAX search panel, and it can search across several post types, taxonomies and custom meta fields at once.
Symptoms that mean you probably need it
You likely need Super Speedy Search if you recognise several of these:
- Search is slow on a large site. Your catalogue or content library has grown and search now takes seconds, spikes your database, or times out under load.
- Results are poor or irrelevant. People search for something you clearly stock or have written about and it does not come up, or the best match is buried several pages down.
- There is no as-you-type search. Visitors have to type a full query and hit a button, then wait for a page reload, instead of seeing instant suggestions and results as they type.
- Search does not cover the fields that matter. Default search ignores custom fields, so SKUs, part numbers, reference numbers, taxonomies and WooCommerce attributes are invisible to your search box.
- You have added SKU-search or similar bolt-ons to patch the gaps, and each one adds another slow query to the search.
- Misspellings kill the result. A single typo returns nothing, when it should still find the obvious match.
- wp-admin search is painful too. Finding products or orders in the dashboard on a large WooCommerce store is slow enough to interrupt your work.
If free-text search on your store already takes several seconds, that is almost always a table scan, and it is exactly the pattern this plugin removes. On real client sites we have seen search go from over five minutes to under 0.2 seconds after switching to fulltext.
On real client catalogues, search that took over five minutes under the default LIKE scan dropped to under 0.2 seconds once it ran against the fulltext index. The bigger your catalogue, the larger that gap.
Who it is for
Super Speedy Search is aimed at:
- Large content libraries and WooCommerce catalogues where default search has stopped scaling.
- Sites where search drives conversion, particularly stores where a visitor who cannot find a product simply leaves.
- Multi-post-type sites that need to search posts, products and custom post types together in one ranked list or in mixed sections.
- Sites that need meta or taxonomy search, for example searching by SKU, reference number, GTIN, brand attribute or category.
- Anyone who wants instant as-you-type search with suggestions, synonyms and misspelling tolerance built in.
Who probably does not need it
There is no benefit to indexing a few hundred posts that MySQL already scans in a few milliseconds. If search is fast and your visitors find what they want today, keep things simple and wait until volume, meta search or as-you-type results actually earn the extra moving part.
If you run a small site, a personal blog, or a shop with a modest catalogue, and default WordPress search already returns the right results quickly, then you do not need this plugin. There is no benefit to indexing a few hundred posts that MySQL can already scan in a few milliseconds. Adding an index table and a rebuild step only makes sense once the volume, or the need for meta and taxonomy search, or the demand for as-you-type results, outweighs the simplicity of leaving search alone. Be honest about your size: if search is fast and your visitors find what they want, keep things simple.
How it compares to heavy external search
Tools like Elasticsearch and hosted search services solve the same relevance and speed problem, but they do it by running a separate search engine alongside WordPress, which you have to host, sync and pay for, and which adds a moving part to your stack. Super Speedy Search deliberately uses native WordPress and MySQL technology instead. Everything lives in your own database as an ordinary indexed table, there is no external service to run, no monthly fee and no data leaving your server. For the majority of WordPress and WooCommerce sites, a properly indexed MySQL fulltext search is more than fast enough, and it keeps your stack simple.
Deciding and next steps
A quick test: if your search is slow, misses obvious matches, ignores your custom fields, or lacks as-you-type results, this plugin is built for you. If default search is fast and accurate for your visitors today, you can safely wait.
If you have decided to go ahead, the Quick Start Guide gets you searching in a few minutes, Installing and configuring Super Speedy Search walks through the settings tabs and the initial table build, and Getting Maximum Speed from Super Speedy Search covers the advanced options once you are up and running.
Comments