Service Portal Performance Degradation with Large Number of ApprovalsDescription Service Portal takes a long time to load when user has a large number of approvals Steps to Reproduce 1. Install the granular delegation plugin (com.glide.granular_service_delegation)2. Add a large number of approvals for the admin user (I've attached a script you can use that adds 1k approvals)3. Load the service portal (<your instance url>/sp)4. Notice that the portal loads quickly5. Change the system property glide.approval.delegation.version to "v2" (from "v3")6. Reload the service portalExpected: The portal loads quicklyActual: The portal takes a long time to load (10+ seconds)Workaround Modify the ApprovalDelegationUtil script include to add a state filter to the approval query: Navigate to the ApprovalDelegationUtil script include: /sys_script_include.do?sys_id=7fa15b4459161410f877a820247284bf Locate the _getMyApprovalsWithOnlyApprovalDelegationPlugin() functionAdd the following query condition: approvalGr.addQuery("state", "requested"); _getMyApprovalsWithOnlyApprovalDelegationPlugin: function() { var answer = []; var approvalGr = new GlideRecord("sysapproval_approver"); approvalGr.addQuery("approver", "IN", getMyApprovals()); approvalGr.addQuery("state", "requested"); // Workaround: Filter for requested approvals only approvalGr.query(); while (approvalGr.next()) answer.push(new String(approvalGr.sys_id)); return answer; , Save the script includeClear cache and test Service Portal performance Related Problem: PRB1965496