In magento we are updating orders in two tables each time, what is the real significance to use two tables,
what is the difference between
sales_flat_order tables ,
why we need to store order details in two tables.
sales_flat_order_grid works like an index to make displaying, sorting and filtering in the order grid faster and not blocking the real order tables. The source of truth for the shop is
The grid table is generated from it (see: Mage_Sales_Model_Resource_Order_Abstract::updateGridRecords().
sales_flat_order_grid table is for the Admin Order grid. In grid magento is showing
billing name and
shipping name, here shipping name and billing name are stored in another table.
To achieve this we have to join many tables, So they are using two different table.
sales_flat_order_grid is for Admin sales grid
And another one(sales_flat_order) is to store order details