How to improve the loading speed of filters on Opencart?

Question

opencart

Tell me what can be done on the site norfin.kiev.ua , where a problem with the speed of opening pages was discovered: when you walk through the categories, the pages open quickly, but when you start choosing a filter by product type in the categories, there is a significant slowdown in opening the filter pages, what can be done , maybe some module needs to be installed? Site on opencart. Thanks to!

Answer 1

look at the mysql slow query log and do a mysql query profiling while the filter is running.
if the category tree is small and there are few products, then most likely there are not enough indexes.
of course, if the hosting itself has no problems
, all the modules that are sold under opencart and which supposedly speed it up are kind of nonsense, all sites are different and their thin places may be different