Right now i am upgrading a Magento store (Having 1.5GB database after deleting logs) from 1.6 to 1.8. I have configured the project on my local development environment but i have found that the Magento instance is running very slow (15 min to display a single page)
I have started debugging the code and found that below code in app\code\core\Mage\Core\Controller\Vaelow rien\Front.php
while (!$request->isDispatched() && $i++<100) {
foreach ($this->_routers as $router) {
if ($router->match($this->getRequest())) {
break;
}
}
}
is taking too long time to execute. There was Approx 90 extension were install and i have removed most of them. Now only 15-20. Is there any way to identity and improve it ?
There are few Magento configuration. There is a need of a good hardware with Apache properly configured to handle.
You first need to make sure your computer where you have installed is good enough to handle Magento with that big data base.
Once done you need to look at configuration points: 1. Cache should be on and is writable. 2. Disbale unwanted modules. 3. Switch on profiler to make our which part of code is consuming lot of time. 4. Use of flat catalog. 5. Run indexing to make sure flat table is in use.
Also : Tweaking magento for performance has lots of speed related pointers.
Few days ago my site also faces the same Problem. This solved my problem, Check your cache and indexing, these shod be enable.
To enable caches : Go to admin panel > system > Cache management To enable Index : Go to admin panel > system > Index management
Also remove the unwanted script running on the sites.
You can go through the below steps for Magento Optimization: