Magento running slow

[abhimarkan]

Hi There,

Our Magento category and catalog search page is running really slow, after running profiler it turns out to be load collection (result below)

EAV:load_collection - 13.042037 seconds

Could anyone please throw some light on how to best optimise the load collection. Site is in production mode.

Thanks

[olukyanenko]

Hi,

Add more memory for your MySQL database.

Like described here - https://magento.stackexchange.com/questions/151222/magento2-mysql-recommeded-configurations

Regards

[jstrez77]

Did upping memory help? In profiling, it didn't seem that the queries were taking as long as the code