When an order is processed, it is necessary to store in some way, so old orders can be looked up later.
My question is which way is the best way to store old orders. I could store it in the database with the original relations to the original items ordered, but this won't work as the item price, item description and so on will change over time.
As I see it, there is two opportunities: flat file system or a new database table.