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.
Add more memory for your MySQL database.