Magento - Zend Table Cache / Performance - Programming Questions - eCommerce Software for Growth, Powered by Open Source

Skip to site navigation »
Skip to main content »
Skip to footer content »

Sales: Call 877.832.5289 (N America)|310.295.4144 (International)

Magento Forum

Zend Table Cache / Performance

developerx Total Posts: 25 Joined: 2007-10-24 Ignore user	Does Magento support Zend Table Cache ? By default, Zend_Db_Table_Abstract queries the underlying database for table metadata upon instantiation of a table object. That is, when a new table object is created, the object’s default behavior is to fetch the table metadata from the database using the adapter’s describeTable() method. $cache = Zend_Cache::factory(’Core’, ‘File’, $frontendOptions, $backendOptions); // Next, set the cache to be used with all table objects Zend_Db_Table_Abstract::setDefaultMetadataCache($cache); http://framework.zend.com/manual/en/zend.db.table.html With a lot of product information retrieving product list and searches is quite slow
	Posted: August 7 2008 \| top

B00MER Total Posts: 33 Joined: 2007-12-27 Ft. Worth Texas Ignore user	What version of magento, and how many products/categories? Are you already utilizing the caching feature under System > Cache management? Also shared or dedicated hosting? Signature Core Action Sports
	Posted: August 7 2008 \| top \| # 1

developerx Total Posts: 25 Joined: 2007-10-24 Ignore user	Version 1.0 and 1.1 with Memcached enabled, around 90,000 products mixed between simple products and configurable
	Posted: August 7 2008 \| top \| # 2

B00MER Total Posts: 33 Joined: 2007-12-27 Ft. Worth Texas Ignore user	If you’ve got a dedicated box, give mytop a try through ssh see if you’ve got any database bottlenecks. http://jeremy.zawodny.com/mysql/mytop/ I’ve not hit anywhere near 90k products, but im defiantly curious how well Magento hands it, so far it seems bleak. From my understanding I think Magento does utilizes Zend cache framework… Signature Core Action Sports
	Posted: August 7 2008 \| top \| # 3

B00MER Total Posts: 33 Joined: 2007-12-27 Ft. Worth Texas Ignore user	Quick search with WinGrep on 1.1.2 I see quite a few references to Zend_Cache. \app\code\core\Zend\Cache\Backend\Memcached.php ... \lib\varien\data\collection\DB.php `/** * Retrieve cache instance * * @return Zend_Cache_Core */ protected function _getCacheInstance() { if (isset($this->_cacheConf['object'])) { return $this->_cacheConf['object']; } return false; }` Signature Core Action Sports
	Posted: August 7 2008 \| top \| # 4

developerx Total Posts: 25 Joined: 2007-10-24 Ignore user	the config is 3 web servers, and 1 database server, all dedicated. Magento only seems to support caching of layout objects, doesn’t seem to cache table meta data. I think this will improve overall performance.
	Posted: August 7 2008 \| top \| # 5

lorik Total Posts: 34 Joined: 2008-08-29 Ignore user	hi what about trafic ? huge ? Please see this post regarding performance, and give your opinion ! This is not spam… http://www.magentocommerce.com/boards/viewthread/18229/
	Posted: September 20 2008 \| top \| # 6

nikefido Total Posts: 421 Joined: 2008-07-11 New Haven, CT Ignore user	Knowing Magento you should probably have 1 web server and 3 database servers Signature @ My Magento Blog - Handy tutorials on programming and designing Magento. A continual work in progress! - Now with a new design, new hosting and a new domain! Check it out!
	Posted: September 20 2008 \| top \| # 7

Magento Community

Magento Community

Back to top

[is anyone here ?] Reset Filter

[API] How to get associated products and how to use "catalog_product_attribute.options"?

Sales: Call 877.832.5289 (North America) 310.295.4144 (International)

© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service Magento Community Count
50153 users|550 users currently online|102300 forum posts