Magento - Top 5 Slowest Magento PHP Functions > 서버관리 Tip

I’ve done a brief sample of tests on Magento’s performance using a large catalog (2000 Categories, 30000+ Products).  I’m running v1.0 on a Windows Vista machine using the php module with an apache web server (see Specs below).  I ran the XDebug PHP Profiler on a sample of page requests and used WinCacheGrind to parse and analyze the results.  For more instructions on getting XDebug set up and to view the results, visit the projects website at http://www.xdebug.org/docs/.

Some background on the customizations to my Magento Installation:
I modified the home page to have a list of categories on the left just as there is in the default template on the catalog/category pages using the same exact catalog/navigation block (Mage_Catalog_Block_Navigation).  So that’s why the load times on the home page are a bit longer than usual.

Page Requests:
1.) Home Page with Catalog Navigation Block
2.) Catalog Category View (Second Level Category)
3.) Home Page with Catalog Navigation Block
4.) Catalog Category View (Third Level Category)
5.) Catalog Cateogry View (Top Most Category)
6.) Home Page without Catalog Navigation Block

(The numbers correspond to the cachegrind.out# output files)

Top 5 Slowest Magento Functions (In alphabetical order):

-Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection->_afterLoad()
-Mage_Core_Block_Abstract->toHtml() (slow because of child functions called inside this one)
-Mage_Core_Block_Template->fetchView() (slow because of child functions called inside this one)
-Varien_Data_Tree_Dbp->addChildNodes() (Veeerrryyyy Slow with lots of categories)
-Varien_Simplexml_Element->extendChild()

I hope these functions get revisited and improved in an upcoming release because I really like Magento and if the performance issues can get worked out, then I think Magento will overtake all other open source shopping carts.

Link to Download the Cachegrind files:
http://rapidshare.com/files/111061427/XDebug.zip.html