Limit records in sales order grid

Question

My sales order table has total 17000 records. Need to select and show only last 300 records in sales order grid. I have tried the below code, but it's not working

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()->limit(300);
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

Answer 1

Here is the working code:

protected function _prepareCollection()
{
    $this->setDefaultLimit(200);
    $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()->limit(300);
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

Since the max limit is 200, you have to set the default limit to 200 and select query limit to 300. This will give you two grid pages.