In our app we have a DataWindow report with a background image that is saved to PDF. A customer reports their C drive being filled up while running the process that creates the PDF. For this customer, the report has about 850 pages. The process saves one PDF of the entire report and then repeatedly filters the DataWindow to a single page and saves each one to PDF. It ends up creating one 850 page file and 850 one page files. The files are saved to the database and deleted as they are created so there should only be one finished file on disk at any one time.
PB version: 12.5
GhostScript version: 8.71 and 9.10 64bit.
Database: SQL Server
The image file is a PNG that covers the entire page. It is about 2650 KB in size. The report is tax form W-2 4 Part which has 4 copies of the form on one page so each page is for a different employee. The employee then uses the companion web application (not written in PB) to download or print the form.
I have looked into using Amyuni for speed purposes but management is reluctant to make that sort of change unless absolutely necessary. Any tips on reducing disk usage or improving the speed of GhostScript would be appreciated.