Limit of 10,000 products in the filter

santfather · Post by **santfather** » 28 Mar 2022, 09:41

Laravel version: 8.80
Aimeos version: 2021.10
PHP version: 8.0.8

There are more than 350K products in our online store. When you open the parent category, the brand filter does not work as it should. Shows only 10000 products (of one brand). When you go deeper into the category, and there are less than 10,000 products, everything works as it should.
Where is this restriction in the filter?
example. parent category

: Screenshot_39.png (19.48 KiB) Viewed 847 times

example. inherited category

: Screenshot_40.png (22.94 KiB) Viewed 847 times

Post by **aimeos** » 29 Mar 2022, 08:40

There's a configurable limit for aggregations because counting a lot of rows is expensive and takes a very long time:
https://aimeos.org/docs/2021.x/config/m ... ger/#limit

Be careful when setting this to higher values and keep an eye on the log panel for slow queries.

santfather · Post by **santfather** » 29 Mar 2022, 10:17

thanks. this solved the problem

Help for Aimeos