Skip to main content
Magento

Return to Question

Grammatical Mistakes corrected
Source Link
edit approved Oct 10, 2019 at 7:20
Ajwad Syed
edit approved Oct 10, 2019 at 7:20
Ajwad Syed
  • 1.6k
  • 28
  • 62

What is the difference between these 2two dB tables? 

I can see for the data, the sales_order_gridsales_order_grid appears to be a subset of sales_ordersales_order. Is this true? What is the processpurpose of havehaving duplicate tables (I assume it is to prevent lock ups).

If I have a custom module andby 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?

What is the difference between these 2 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 process of have duplicate tables (I assume it is to prevent lock ups).

If I have a custom module and which 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?

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?

Source Link
user3313446
user3313446
  • 21
  • 1
  • 2

Sales order vs sales order grid

What is the difference between these 2 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 process of have duplicate tables (I assume it is to prevent lock ups).

If I have a custom module and which 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?