Why is PrestaShop search slow?
PrestaShop’s search is better built than most — a real word index rather than a wildcard scan. It still runs on your server, in your database, competing with the pages and checkouts that pay for it.
The cause
The index grows faster than the catalogue
Every distinct word in every product’s text, in every language, becomes a row in `ps_search_word`, and every product-to-word relationship a row in `ps_search_index`. The second table is the one that gets large: it is products multiplied by words, not products.
A search then joins both, scores the matches by field weight, and sorts. That is real work, done by your database, on the same connection pool as the rest of the shop.
The cliff
PrestaShop has a number written into the source
`Search::PS_SEARCH_MAX_WORDS_IN_TABLE` is 100,000. Above that, the scoring coefficients PrestaShop uses to weight word length flatten toward 1 — its own code comments describe the table as able to "grow huge, and exceed server resources".
That is a design acknowledging its own ceiling, and it is a ceiling a multilingual catalogue of a few thousand products can reach.
The fix
Take the query off the shop entirely
NitroSearch answers from a dedicated engine, with the query travelling from the shopper’s browser and never touching your hosting. Search stops competing with checkout for the database, and the response comes back in around a tenth of a second whether the shop is idle or in a sale.
More about PrestaShop search
Why is PrestaShop search slow on a big catalogue?
The word index grows as products multiplied by distinct words multiplied by languages, and every search joins and scores against it on your own database — alongside page loads and checkout.
Does the search index have a size limit?
Not a hard one, but PrestaShop’s own source defines `PS_SEARCH_MAX_WORDS_IN_TABLE` as 100,000 and flattens its length-weighting coefficients above it, with a comment about the table growing huge enough to exceed server resources.
Will better hosting fix it?
It buys margin. The work is unchanged and it still shares the database with the rest of the shop, so the problem returns at the next traffic peak rather than being solved.
How fast is NitroSearch?
Typically around a tenth of a second, from an engine that does nothing else, with your own server not involved in the query at all.
PrestaShop behaviour on this page last checked against a live PrestaShop 8 install on 2026-08-04.
Other PrestaShop search topics
Give your shoppers search that finds things
Free up to 100 search results, no card, no time limit. Paid plans start at $5.99/mo and are priced by catalogue size — never per search.