My collection model is testimonial/record
. In database table(testimonial_record
) 2,00,000 records so it loads more how to decrease time to fetch collection data in grid.So I think I have to store collection in cache to display in grid.is this good approach ? if good approach how to store collection in cache.
How can use below cache function in collection grid ?
Mage::app()->saveCache($data, $this->_cacheId, array(self::CACHE_TAG), 604800);
my Grid.php
protected function _prepareCollection()
{ $collection = Mage::getModel("testimonial/record")->getCollection();
$this->setCollection($collection);
return parent::_prepareCollection();
}