My Classic ASP app is using COM version of ActiveReports to get data out of a very small SQL server 2008 database (less than 200MB) and generating PDFs on request from the simple ASP app. The PDF size is about 8KB. The ASP server runs on W2k3R2 64-bit. I had done the following:
The ASP server was on the UAT domain while we were testing, and it used to be able to produce the PDF reports within 5 seconds...then the management decided to 'join' the PROD domain instead; and for some strange reasons, the PDF generation processes took 1-5 minutes instead of seconds. Regardless on unregistering/registering the DLLs again, numerous IIS restarts, adding IUSRS and IWAM users into the local admin group, and re-enabling 32-bit support within IIS, there is no improvements in performance.
Using the SQL profiler, we are 100% sure the bottleneck is not caused by SQL connections, but the generation of PDFs.
We are totally baffling with this problem, is there anything else we should look at, apart from changing server (as a last resort)? Thanks.
pause can be caused by attempt to access to the printer settings in the rendering engine, please try to use MyReport.Printer.DeviceName = "" code before MyReport.Run()