Bi Publisher Consuming 90% CPU
Hello Everyone,
I appreciate if you could help me with any thoughts you might have on the following scenairo:
I have created a page which has a single button to generate a PDF file using PSXP_XMLGEN and PSXP_RPTDEFNMANAGER peoplecode classes.
There is no calculation in the program as the data is already saved in a table and just one row of data gets loaded into the PDF.
If not thousands, at least hundreds of employees could try to access this pdf file at a time.
After montoring the PSAPPSRV, we found out that one single PDF generated through this page caused an 87% CPU usage.