Tuesday, January 6, 2015

Magento collection caching

When we talk about Magento, we should try to optimize site loading speed as much as possible.

Sometimes block caching is not enough and we should also use collection caching to achieve best results.

Here is simple way to use cached collection in Magento.

Let's add this method in our class where we will create and use Magento collection:

    public function _prepareCollectionCache($collection)
        if (Mage::app()->useCache('collections')) {

            $cache = Mage::app()->getCache(); //Let's get cache instance
            $cache->setLifetime(86400); //Here we set collection cache lifetime

                'Bestsellers_', //this is just custom prefix

        return $collection;

After that, when our collection is prepared, let's just pass it through method above.
For example:
        $categoriesCollection = Mage::getModel('catalog/category')->getCollection();

        $categoriesCollection->addFieldToFilter('entity_id', array('in' => $catIds));

        $categoriesCollection->addFieldToFilter('is_active', array('eq' => true));
        $categoriesCollection->getSelect()->order(array('level DESC'));

        $categoriesCollection = $this->_prepareCollectionCache($categoriesCollection);
This is it. Our category collection will be cached from now on.

If you are interested what is actually happening and how this collection caching mechanism works, just take a look at Varien_Data_Collection_Db class which is one of the parent classes that every Magento collection extends.

 It contains whole caching mechanism which uses parameters that we provided by calling "initCache" on collection object.

 I hope that you will find this little tip useful. Cheers

, ,


Post a Comment