I need a suggestion in magento.
I have created custom model collection.it has around
50,000 rows in
testimonial_record. I want to fetch simply all data.
Which following query is best to fetch fast data ?
$resource = Mage::getSingleton('core/resource'); $readConnection = $resource->getConnection('core_read'); $query = 'SELECT * FROM ' . $resource->getTableName('testimonial_record'); $results = $readConnection->fetchAll($query);
$collection = Mage::getModel('testimonial/record')->getCollection();
Which one above technique is best to fetch fast bulk data ? OR any other query to fetch fast data from custom table ?