dc_guy Posted June 9, 2005 Posted June 9, 2005 I haven't found a contribution that allows you to archive an order rather than deleting it. Does one of these exist? If not, I'm just going to set this up myself. But I had a question. What is the better way to go about archiving an order? I figure it would be done between the following 2 ways: (1) New Field - Create a new field in the order tables to act as an archive flag. Adjust queries to NOT report on orders flagged as archived. (2) New Tables - Create new archive tables, and move the entire records from the "live" tables to the "archived" tables. Which of these methods would be a more efficient way to implement this feature, if its not already implemented? Would moving records from the "live" orders tables increase the speed of queries at all.. or should it not make a difference keeping them all in the same tables?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.