Copy Dataset Performance Improvement (AGS-18080)

Benefits

• Improve the speed at month-end, especially in larger datasets

• Reduce user downtime when “rolling” the month during month-end closeout.

Description

Multiple changes were added that resulted in significant performance improvements within the Copy Dataset processes.

• Temp Files were moved to a dedicated “temp file” folder

• The “Copy Spooled Reports and Forms” questions have been consolidated to one question

• Performance has been improved

• File copy processes have been optimized

• The copy process now creates a Log File to record the events that occurred during the copy procedure.

The resulting performance improvement should be seen between 20% -60% improvements depending on the dataset size. These improvements are similar for MSSQL and ZEN “PSQL” databases.

Related content