I inherited a project from a work colleage about a year ago now. It's a Magento 1.9.2.1 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.
Best Answer
Just and idea. This could be due to some module making an http request and not getting a response.
Try to debug this lib/Zend/Http/Client.php :: request()
Place a die(); statement there and see if it breaks your frontend. Sometimes modules check their license on every request