[WT-11030] Performance Engineering - Optimization of Check Eligibility - Workterra Jira

Details

Type: Enhancement
Status: Closed
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: Performance Management
Labels:
None

Module:
Performance Management
Reported by:
Harbinger
Item State:
Stage QA - Production Deployment on Hold
Severity:
Simple

Description

Current Implementation :
On Enroll now FetchDemographicEligibility and FetchCheckEligibilityForPlanDesign execute multiple times with same Criteria with in transaction.

New Implementation :
Optimizing FetchDemographicEligibility and FetchCheckEligibilityForPlanDesign
cache output Criteria/Employee/Effective date wise in hashtable with in transaction whenever same criteria execute it will returns output from hashtable no need to execute same criteria every time in single transaction.
Impacted Area :Enroll Now and Import functionality.
Affected File :GenericEligblityCheck.vb,Eligibility.VB

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

TestCases.xls
12 kB
22/Sep/17 12:24 PM
WT11030.xls
9 kB
28/Sep/17 09:33 AM

Activity

Ascending order - Click to sort in descending order

Roshan Deshmukh (Inactive) created issue - 11/Sep/17 11:57 AM

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 11:58 AM

Field	Original Value	New Value
Assignee	Vijay Siddha [ vijays ]	Roshan Deshmukh [ roshan.deshmukh ]

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 11:58 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 11:59 AM

Description	Current Implementation : On Enroll now FetchDemographicEligibility and FetchCheckEligibilityForPlanDesign execute multiple times with same Criteria with in transaction. New Implementation : Optimizing FetchDemographicEligibility and FetchCheckEligibilityForPlanDesign cache output Criteria/Employee/Effective date wise in hashtable with in transaction whenever same criteria execute it will returns output from hashtable no need to execute same criteria every time in single transaction. Impacted Area :Enroll Now and Import functionality. Affected File :GenericEligblityCheck.vb,Eligibility.VB	Current Implementation : On Enroll now FetchDemographicEligibility and FetchCheckEligibilityForPlanDesign execute multiple times with same Criteria with in transaction. New Implementation : Optimizing FetchDemographicEligibility and FetchCheckEligibilityForPlanDesign cache output Criteria/Employee/Effective date wise in hashtable with in transaction whenever same criteria execute it will returns output from hashtable no need to execute same criteria every time in single transaction. Impacted Area :Enroll Now and Import functionality. Affected File :GenericEligblityCheck.vb,Eligibility.VB
Developer		Roshan Deshmukh [ roshan.deshmukh ]

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 12:01 PM

Remaining Estimate		32h [ 115200 ]
Original Estimate		32h [ 115200 ]

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 01:03 PM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 01:03 PM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Roshan Deshmukh (Inactive) made changes - 11/Sep/17 01:06 PM

Remaining Estimate	32h [ 115200 ]	23.5h [ 84600 ]
Time Spent		8.5h [ 30600 ]
Worklog Id		78034 [ 78034 ]

Roshan Deshmukh (Inactive) made changes - 12/Sep/17 05:10 AM

Summary

Performance Engineering - Optimize Check Eligibility function

Performance Engineering - Optimization of Check Eligibility

Roshan Deshmukh (Inactive) made changes - 12/Sep/17 05:27 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Roshan Deshmukh (Inactive) made changes - 12/Sep/17 05:27 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Roshan Deshmukh (Inactive) made changes - 12/Sep/17 05:27 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Roshan Deshmukh (Inactive) made changes - 12/Sep/17 05:31 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Roshan Deshmukh (Inactive) made changes - 12/Sep/17 11:18 AM

Remaining Estimate	23.5h [ 84600 ]	18.5h [ 66600 ]
Time Spent	8.5h [ 30600 ]	13.5h [ 48600 ]
Worklog Id		78186 [ 78186 ]

Roshan Deshmukh (Inactive) made changes - 15/Sep/17 04:53 AM

Remaining Estimate	18.5h [ 66600 ]	15h [ 54000 ]
Time Spent	13.5h [ 48600 ]	17h [ 61200 ]
Worklog Id		78830 [ 78830 ]

Roshan Deshmukh (Inactive) made changes - 15/Sep/17 04:54 AM

Worklog Id

78830 [ 78830 ]

Roshan Deshmukh (Inactive) made changes - 15/Sep/17 10:26 AM

Code Review Date		15/Sep/2017
Code Reviewed By		Amruta Lohiya [ 11906 ]
Item State	Parent values: Development(10200)Level 1 values: Ready for Review(10208)	Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Khandu Kshirsagar (Inactive) made changes - 18/Sep/17 10:54 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Roshan Deshmukh (Inactive) made changes - 18/Sep/17 11:24 AM

Assignee

Roshan Deshmukh [ roshan.deshmukh ]

Rakesh Roy [ rakeshr ]

Rakesh Roy (Inactive) made changes - 18/Sep/17 11:39 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Rakesh Roy (Inactive) made changes - 18/Sep/17 11:40 AM

Assignee

Rakesh Roy [ rakeshr ]

Prasad Pise [ prasadp ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 04:57 AM

Remaining Estimate	15h [ 54000 ]	13.5h [ 48600 ]
Time Spent	17h [ 61200 ]	18.5h [ 66600 ]
Worklog Id		79395 [ 79395 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 04:57 AM

Worklog Id

79395 [ 79395 ]

Hrishikesh Deshpande (Inactive) made changes - 19/Sep/17 11:11 AM

Assignee

Prasad Pise [ prasadp ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 11:49 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 11:49 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 11:49 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Roshan Deshmukh [ roshan.deshmukh ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 12:44 PM

Remaining Estimate	13.5h [ 48600 ]	9.5h [ 34200 ]
Time Spent	18.5h [ 66600 ]	22.5h [ 81000 ]
Worklog Id		79760 [ 79760 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 12:45 PM

Worklog Id

79760 [ 79760 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 12:45 PM

Worklog Id

79760 [ 79760 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 12:45 PM

Remaining Estimate	9.5h [ 34200 ]	7.5h [ 27000 ]
Time Spent	22.5h [ 81000 ]	24.5h [ 88200 ]
Worklog Id		79760 [ 79760 ]

Roshan Deshmukh (Inactive) made changes - 19/Sep/17 12:45 PM

Worklog Id

79760 [ 79760 ]

Roshan Deshmukh (Inactive) made changes - 20/Sep/17 10:44 AM

Assignee

Roshan Deshmukh [ roshan.deshmukh ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Roshan Deshmukh (Inactive) made changes - 20/Sep/17 10:45 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Roshan Deshmukh (Inactive) made changes - 21/Sep/17 04:43 AM

Remaining Estimate	7.5h [ 27000 ]	0h [ 0 ]
Time Spent	24.5h [ 88200 ]	32.5h [ 117000 ]
Worklog Id		80084 [ 80084 ]

Roshan Deshmukh (Inactive) made changes - 21/Sep/17 04:44 AM

Worklog Id

80084 [ 80084 ]

Rakesh Roy (Inactive) made changes - 22/Sep/17 05:38 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Prasad Pise [ prasadp ]

Prasad Pise (Inactive) made changes - 22/Sep/17 06:18 AM

Assignee

Prasad Pise [ prasadp ]

Jayshree Nagpure [ jayshree.nagpure ]

Priya Dhamande (Inactive) made changes - 22/Sep/17 06:40 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 22/Sep/17 12:18 PM

Time Spent	32.5h [ 117000 ]	34.5h [ 124200 ]
Worklog Id		80604 [ 80604 ]

Jayshree Nagpure (Inactive) made changes - 22/Sep/17 12:22 PM

Attachment

TestCases.xls [ 62432 ]

Jayshree Nagpure (Inactive) made changes - 22/Sep/17 12:24 PM

Attachment

TestCases.xls [ 62432 ]

Jayshree Nagpure (Inactive) made changes - 22/Sep/17 12:24 PM

Attachment

TestCases.xls [ 62433 ]

Jayshree Nagpure (Inactive) made changes - 22/Sep/17 12:25 PM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Prasad Pise [ prasadp ]

Priya Dhamande (Inactive) made changes - 22/Sep/17 01:18 PM

Time Spent	34.5h [ 124200 ]	37h [ 133200 ]
Worklog Id		80679 [ 80679 ]

Prasad Pise (Inactive) made changes - 25/Sep/17 09:22 AM

Time Spent	37h [ 133200 ]	37.5h [ 135000 ]
Worklog Id		80992 [ 80992 ]

Prasad Pise (Inactive) made changes - 26/Sep/17 01:07 PM

Time Spent	37.5h [ 135000 ]	37.75h [ 135900 ]
Worklog Id		81671 [ 81671 ]

Prasad Pise (Inactive) made changes - 27/Sep/17 08:59 AM

Assignee

Prasad Pise [ prasadp ]

Priya Dhamande [ priya.dhamande ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 08:51 AM

Attachment

Stage_TabLogo.jpg [ 62931 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 08:51 AM

Attachment

CALogin_Loader.jpg [ 62932 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 08:51 AM

Attachment

EmpLogin_Loader.jpg [ 62933 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 08:51 AM

Attachment

CALogin_Loader.jpg [ 62932 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 08:51 AM

Attachment

Stage_TabLogo.jpg [ 62931 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 08:51 AM

Attachment

EmpLogin_Loader.jpg [ 62933 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 09:33 AM

Attachment

WT11030.xls [ 62943 ]

Priya Dhamande (Inactive) made changes - 28/Sep/17 09:43 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Priya Dhamande (Inactive) made changes - 03/Oct/17 06:01 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Priya Dhamande (Inactive) made changes - 03/Oct/17 06:01 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Khandu Kshirsagar (Inactive) made changes - 03/Oct/17 07:58 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Priya Dhamande (Inactive) made changes - 03/Oct/17 08:46 AM

Time Spent	37.75h [ 135900 ]	39.75h [ 143100 ]
Worklog Id		82953 [ 82953 ]

Priya Dhamande (Inactive) made changes - 03/Oct/17 08:47 AM

Time Spent	39.75h [ 143100 ]	40.75h [ 146700 ]
Worklog Id		82954 [ 82954 ]

Priya Dhamande (Inactive) made changes - 03/Oct/17 01:13 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Priya Dhamande (Inactive) made changes - 03/Oct/17 01:13 PM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Priya Dhamande (Inactive) made changes - 06/Oct/17 05:21 AM

Time Spent	40.75h [ 146700 ]	43.75h [ 157500 ]
Worklog Id		83500 [ 83500 ]

Priya Dhamande (Inactive) made changes - 06/Oct/17 05:58 AM

Assignee

Priya Dhamande [ priya.dhamande ]

Jayshree Nagpure [ jayshree.nagpure ]

Priya Dhamande (Inactive) made changes - 06/Oct/17 05:59 AM

Time Spent	43.75h [ 157500 ]	45.75h [ 164700 ]
Worklog Id		83527 [ 83527 ]

Priya Dhamande (Inactive) made changes - 09/Oct/17 06:39 AM

Time Spent	45.75h [ 164700 ]	46.75h [ 168300 ]
Worklog Id		83527 [ 83527 ]

Jayshree Nagpure (Inactive) made changes - 11/Oct/17 04:49 AM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Priya Dhamande [ priya.dhamande ]

Jayshree Nagpure (Inactive) made changes - 11/Oct/17 04:58 AM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Rakesh Roy (Inactive) made changes - 17/Oct/17 11:17 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)

Rakesh Roy (Inactive) made changes - 13/Apr/18 05:25 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Rakesh Roy (Inactive) made changes - 13/Apr/18 05:25 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Rakesh Roy (Inactive) made changes - 13/Apr/18 05:25 AM

Status

Approved for production [ 10034 ]

In Production Testing [ 10202 ]

Rakesh Roy (Inactive) made changes - 13/Apr/18 05:26 AM

Resolution		Done [ 10000 ]
Status	In Production Testing [ 10202 ]	Production Complete [ 10028 ]

Rakesh Roy (Inactive) made changes - 13/Apr/18 05:26 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

People

Assignee:: Priya Dhamande (Inactive)

Reporter:: Roshan Deshmukh (Inactive)

Developer:: Roshan Deshmukh (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 11/Sep/17 11:57 AM

Updated:: 13/Apr/18 05:26 AM

Resolved:: 13/Apr/18 05:26 AM

Code Review Date:: 15/Sep/2017

Time Tracking

Estimated:

32h

Remaining:

Logged:

46.75h