What is the difference between these two dB tables?
I can see for the data, the sales_order_grid appears to be a subset of sales_order. Is this true? What is the purpose of having duplicate tables (I assume it is to prevent lock ups).
If I have a custom module by which I want to add a field to an order, which table do I need to add the field to? And how do I ensure the data is consistent?