PowerBuilder 2022 Build 1892
SQL Server using MSOLEDBSQL19 database driver.
A customer reports that the print payroll checks process that runs in 5 minutes with locally installed app takes 40 minutes when run via RemoteApp. The previous version of our app didn't have this issue. It was PB 2019 Build 2170 and used the SNC database driver.
This process does a SaveAs to PDF, reads it into a blob, and stores it in the database. I did a simple test to compare generating the PDF using Ghostscript, NativePDF to file, and NativePDF direct to blob. Local and remote timings were different but not enough to explain the process taking 8 times as long.
Does anyone have any ideas on what to look for?
My special test used a one page report and had three loops 100 times each:
Ghostscript to file: local 72 seconds, remoteapp 149 seconds
NativePDF to file: local 41 seconds, remoteapp 149 seconds
SaveNativePDFToBlob: local 38, remoteapp 103 seconds
The report was retrieved once before timing started and there was no SQL during the tests. I'm going to try to create a SNC login profile so I can choose between SNC and MSO on the login window.