Subject: | ESS Performance issues |
Summary: | Using a database that has a large number of employees, navigate into each form and review performance. Use SQL Trace to identify where performance issues are and correct accordingly. Log the following details on this case: - Client database name
- Form Name
- Response time
- Corrections made (Y/N) - To be used by Rashna to determine which forms to check
|
Audit Notes: | Edited by sanjay on 08/12/20 09:39. Edited by sanjay on 05/03/19 09:36. |
01 Nov 2018 | 03:09PM Comment 1 by Sanjay (Link Technologies) Case 9688 added to project 10.0 |
02 Nov 2018 | 03:20PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 02-11-2018 03:20 PM Time Taken: 2.00 |
| Below is a list of forms that were slow in loading: Client Name | Form Name | Response Time | Corrections Made | Response time after correction | PAFCO | Employee Profile ~> Meetings | 5s | Changes made to function LT_SYS_UserList_fx to improve performance. | < 1s | PAFCO | Time View - Week | 5s | Added cache on time view select procedure. Refactored function LT_ESS_GetReportingCompanyEmployeeID_fx | 1.5s | PAFCO | Time View - Calendar | 3.5s | Refactored procedure LT_ESS_TimeCalendar_SELECT
| < 1s | PAFCO | Time Approval | 1.7s | No change |
|
|
|
05 Nov 2018 | 08:54AM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 05-11-2018 08:54 AM Time Taken: 1.00 |
| Below is a list of forms that were slow in loading: Client Name | Form Name | Response Time | Corrections Made | Response time after correction | LTA | FMISIntegration.aspx | 11s | Refactored procedure LT_PAY_FMISIntegrationTransactions_SELECT | < 1s | LTA | Procedure: LT_SYS_User_LIST2 used by: 1. MaintainApprovalWorkflow.aspx 2. Tasks.aspx
| 4s | Refactored procedure LT_SYS_User_LIST2 | < 1s |
|
|
05 Nov 2018 | 04:42PM Comment 4 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 05-11-2018 04:42 PM Time Taken: 6.00 |
| Below is a list of forms that were slow in loading: Client Name | Form Name | Response Time | Corrections Made | Response time after correction | HA | LeaveAdjustments.aspx | 2s | Changed the form as follows: - Added date range filters
- All leave adjustments that are not approved are shown on the top regardless of the date range chosen.
- Employee list when adding or editing is all active employee
| < 1s |
|
|
06 Nov 2018 | 12:55PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 06-11-2018 12:55 PM Time Taken: 2.00 Notes: Edited by rashna on 06/11/18 12:56. |
| Hi Sanjay, The case has been successfully tested. Name | Form Name | Response Time | Corrections Made | Response time after correction
| QA Results. tested with user "Tomasi". Time recorded with a stopwatch | PAFCO | Employee Profile ~> Meetings | 5s | Changes made to function LT_SYS_UserList_fx to improve performance. | < 1s | 4.43s | PAFCO | Time View - Week | 5s | Added cache on time view select procedure. Refactored function LT_ESS_GetReportingCompanyEmployeeID_fx | 1.5s | 3.54s | PAFCO | Time View - Calendar | 3.5s | Refactored procedure LT_ESS_TimeCalendar_SELECT
| <1s | 3.87s | PAFCO | Time Approval | 1.7s | No change |
| 4s |
Client Name | Form Name | Response Time | Corrections Made | Response time after correction | QA Results. tested with user "Priya.Chand". Time recorded with a stopwatch
| LTA | FMISIntegration.aspx | 11s | Refactored procedure LT_PAY_FMISIntegrationTransactions_SELECT | < 1s | 1.91s | LTA | Procedure: LT_SYS_User_LIST2 used by: 1. MaintainApprovalWorkflow.aspx 2. Tasks.aspx
| 4s | Refactored procedure LT_SYS_User_LIST2 | < 1s | Tasks - 2.93s Approval Workflow - 2.31s User Workflow - 2.04s |
Client Name | Form Name | Response Time | Corrections Made | Response time after correction | QA Results. tested with user "nsimmon". Time recorded with a stopwatch
| HA | LeaveAdjustments.aspx | 2s |
Changed the form as follows: - Added date range filters
- All leave adjustments that are not approved are shown on the top regardless of the date range chosen.
- Employee list when adding or editing is all active employee
| < 1s | 1.40s |
Next Step - Document changes on Leave Adjustment screen. |
|
06 Nov 2018 | 01:40PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-11-2018 01:40 PM Time Taken: 1.00 |
| Hi Sanjay, This case has been tested as per comment 5. All screens are loaded in less than 5 seconds. Documentation has been completed on the case. Documentation Updated under -- Link Web Application Porta -- Employee Leave -- Leave Adjustments. Thanks Rashna |
|
06 Nov 2018 | 02:47PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-11-2018 02:47 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 8 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |
08 Dec 2020 | 09:39AM Comment 9 by Sanjay (Link Technologies) ETC was changed from 06/11/2018 to 06/11/2018 |