Performance Improvements via Jobstream
The Stock Audit Table records every single stock transaction that occurs on your system. Stock transactions are not only Book stock, but also quantity change actions linked to Sales Orders, Purchase Orders and Production Orders, amongst many others.
If you find that:
- the backup of your database is taking longer and longer to complete
- there is insufficient disc space when a copy of LIVE to TEST is required
then it is time to perhaps consider having your Stock Audit Table purged.
This purging process can be set up as part of your overnight Jobstream function, by an Apparel21 consultant. The initial bulk purging of the Stock Audit table will need to be actioned progressively, over a period of time, based on the volume of data to be removed, to avoid any service disruptions to your database.
Over time, the optimisation of this table to will help improve speed to access and write data to/from this table to improve overall performance of your Apparel21 system.