Translations:Developers/Optimize performance/3/en

To get a good performance you should always try to minimize the number of rows that matches as fast as possible. One good possibility is search only for products in the current category. As the number of products per category is usually low, this quickly reduces the number of rows that has to be filtered afterwards. When using the catalog index manager, add the following search condition first: