Issue
Larger db slows down systems. Online more so.
Currently, local import tables are only relevant until order is brought into am and order is assigned an SO number. Thereafter, we can use the am records to reference and update online info.
How long to leave an order in the online system before archiving ?
Do we keep a copy of the discarded imported orders, or just destroy them ?
Possible Feature
User has option to choose "Don't Archive" on certain orders, which will retain them in system indefinitely.
Issue Larger db slows down systems. Online more so. Currently, local import tables are only relevant until order is brought into am and order is assigned an SO number. Thereafter, we can use the am records to reference and update online info.
How long to leave an order in the online system before archiving ?
Do we keep a copy of the discarded imported orders, or just destroy them ?
Possible Feature User has option to choose "Don't Archive" on certain orders, which will retain them in system indefinitely.