I have a Magento store running with over 18,000 order records all the other pages within admin load within 1 - 2 seconds apart from Sales>Orders this can take anything between 5 - 20 seconds to load.

It is set at the standard displaying 20 records per page | Total 18000 records found

How can I either speed this page load time or limit the records to the last 3,000 total records so the page loads faster?

I have optimised the Database, Optimised the Server everything I've done has improved the rest of the site on the frontend and backend apart from this page?

Any help appreciated as this is having an impact on the daily running of the site for anyone working within the admin.

  • If your grid is customized then you should check the for the column which is taking too much time to load.
    – Saphal Jha
    Commented May 8, 2019 at 17:39
  • how do i do that?
    – Malc Sag
    Commented May 9, 2019 at 8:28
  • you need to debug it, disable extensions which is related to it and check it.
    – Saphal Jha
    Commented May 9, 2019 at 8:50

1 Answer 1


you can override the grid prepareCollection method by this code

protected function _prepareCollection()
  $collection = Mage::getResourceModel($this->_getCollectionClass());
  return parent::_prepareCollection();

You have to set the default limit to 200 and select query limit to 3000. This will give you 15 grid pages with total 3000 order.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.