I inherited a project from a work colleage about a year ago now. It's a Magento 220.127.116.11 store (heavily customised) and after reviewing areas of code, I almost had a heart attack.
Up until the beginning of February the site has been running fast without any issues. However the site has suddenly slowed up. Page load times have gone from 1-2 seconds to 7-11 seconds.
No code or updates have been made to the store, which makes me think it could be a database issue. However, I have checked all of the culprit tables (log tables truncated and optimised, Core URL rewrites at a stable amount), but no joy.
This is happening on all pages across the site, category, home and product pages.
I have resorted to creating a copy of the site and turning on the profiler (first time using this). Looking through the output of the profiler it seems the speed decrease is coming from the following areas in the profile tree:
mage 8.6182 mage::dispatch::routers_match 8.5354 mage::dispatch::controller::action::catalog_category_view: 8.5129 layout/db_update: default 8.4524 layout/db_update: MAP_popup 8.4476 layout/db_update: SHORTCUT_popup 8.4465 layout/db_update: SHORTCUT_uk_popup 8.4452 layout/db_update: catalog_category_layered 8.4444 layout/db_update: CATEGORY_260 8.4434 layout/db_update: customer_logged_out 8.4423 mage::dispatch::controller::action::catalog_category_view::layout_render 8.3916
All caches are turned on, but yet after the initial load of a page, any subsequent load is still just as slow.
Can anybody point me in the right direction as I have come to a dead end.
The admin area is still quick and nippy.