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:
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.
- 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_tmpand so on.
- I have tried optimizing MySQL with no improvement to this slow load time.
- Magento ver. 126.96.36.199