1

The TTFB on this website I've been put in charge with is extremely slow with a custom made template and a few plugins which I've tried disabling with no luck. Using the inbuilt profiler with the Aoe_Profiler plugin, I've retrieved the following results:

config/load-db slow

It shows that config/load-db is taking almost the whole 4 seconds of the processing time. I'm not too savvy with Magento and was wondering if there was any way to further debug and find what specific areas of the database are causing this massive page load.

Additional Information:

  • Disabling the modules does not do anything
  • The database is reasonably large at about 90mb+ but the majority of it is in temp and log tables e.g. catalog_product_index_eav_tmp and so on.
  • I have tried optimizing MySQL with no improvement to this slow load time.
  • Magento ver. 1.9.1.1

closed as off-topic by Raphael at Digital Pianism, Marius Mar 18 '16 at 9:28

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on problems in code you've written must describe the specific problem and include valid code to reproduce it. For help writing short, self-contained syntactically-valid examples, see: http://sscce.org/" – Raphael at Digital Pianism, Marius
If this question can be reworded to fit the rules in the help center, please edit the question.

0

It was essentially just a host problem. After swapping hosts, it's perfectly fine.

Not the answer you're looking for? Browse other questions tagged or ask your own question.