Does anyone know of anyway to improve the performance of downloading the results of a query to excel from with PeopleSoft Query Manager? Is there any change to the WEBLIB_QUERY.ISCRIPT1.FieldFormula.IScript_ToExcel that can be done to improve performance?
Example: downloading the result set from the PS_ACAD_PLAN_TBL which has 33 columns and 2542 rows of data takes on average 1 minutes 30 seconds to complete irrelevant of the browser that is used.
Campus Solutions 9.0
PeopleTools 8.53.12 - we do have PSQRYSRV configured on our application servers
Red Hat Enterprise Linux Server release 6.5
Oracle 184.108.40.206 - RAC
Client workstation details:
Google Chrome Version 36.0.1985.125 m
Internet Explorer Version 11.0.9600.17207
Microsoft Excel 2010 32-bit
Microsoft Windows 7 64 Bit
Thanks for any thoughts or guidance anyone could provide,
PeopleSoft Systems Administrator, UIS
University of Colorado
1800 Grant Street, Suite 200
Denver, Colorado 80203