I'm having issues with my site not loading category pages, they take ages to load, i have quite a few configurable products.
I cannot for the life of me find out what is causing this issue, sometimes the back-end would freeze if i try to click a category on my page.
Any idea what could be causing this issue? i refreshed and re-indexed etc still nothing.
Please help v___v
P/s im on AWS amazon dedicated EC2 Server