什么导致减速Magento速度

Question

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 ?

Answer 1

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.