0 Replies Latest reply: Aug 6, 2014 4:49 PM by 2609067 RSS

    PeopleSoft Query Manager - Download Results to Excel - Performance Issue

    2609067

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