Translations:Developers/Optimize performance/7/en

In product lists for categories sorting is necessary to match the order of products intended the shop owner. That's not a problem because the number of products per category is in a reasonable range. But when searching for products globally, this can be a big performance hit if the first condition don't reduce the number of rows drastically.