Documentation Home

Performance Suggestions

Startswith for String Filtering

For very large catalogs (1 million+ Skus) filtering in the admin can take a very long time, specifically for String fields. This is partly because the default query is built with wildcards on either side of the search term like:

SELECT * FROM BLC_SKU WHERE LIKE "%filter-string%"

(such as %filter-value%). This does not use indexes very efficiently. By setting the property to true in your properties files:

This modifies the query to instead use a query like filter-value%:


This modification along with proper indexing has been known to cut filtering time in half.