I have added several columns to
sales_order_grid_items so that I can see product attributes in the products sold report.
Since products are likely to be deleted I cannot do a 'join' to the product in the report and expect to retrieve attribute values. So the extra attributes need to be stored somewhere.
Does anyone have idea as to the performance considerations of adding columns to
In theory I could serialize my extra columns and spend ages trying to work out how to display them in the products_ordered report, however, are there likely to be performance benefits?