0 Replies Latest reply on Aug 6, 2014 9:49 PM by 2609067

    PeopleSoft Query Manager - Download Results to Excel - Performance Issue


      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.


      Installation Details:

      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 - 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,


      Reid March

      PeopleSoft Systems Administrator, UIS

      University of Colorado

      1800 Grant Street, Suite 200

      Denver, Colorado 80203