=>$orderIds]);$orderCollection->getSelect()->joinLeft([ When your shop grows past a few thousand orders, the sales order grid slows down, the order view page takes seconds to load, exports time out, and your customer service team starts waiting on screens instead of helping customers. One day the grid loads in 300ms, a year later it takes 8 seconds — and nobody knows why. This guide breaks down the three biggest order-management bottlenecks in Magento 2, and what to do about each one. How Magento 2 Stores and Loads Orders Before optimizing, it helps to understand the sales data model.