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.