Hi,
I am developing Retails POS system. Therefore, the number records of sales, sales item, and other such as log/transaction will grow and grow. For improvement of performance and also table capacity limitation, I would like to have PURGE function for my client.
I have a question here, the transaction/log records may be used for certain module for calculation, validation and etc. THerefore, once the records being purged, the particular module may not able to return correct result to user. What should I do, in order to solve these problems?

Thank you