Dynamic recalculation takes the most resources, especially if you have a lot of taxonomies. the reason is that to get each counter, the filter makes a search query to the database and as a result, even for small filters, the number of requests can reach thousands. But you can optimize it:
You can turn off dynamic recalculation for unimportant filter elements. An example here
Use filter caching. This option greatly reduces the number of database queries and speeds up filtering. But be careful! use this option only after you have completely configured your filter and website. Remember to clear this cache after every filter change and after product updates
- First level of optimization - this optimization is useful if the filter has many meta fields
- Advanced optimization - This is a very powerful optimization. This setting caches all filters, which significantly reduces the number of queries to the database. But be careful - Always clear your cache after changing filters and product data
- Cache lifetime - time period for automatically clearing the cache. If you frequently change product data, set the period shorter
