Description |
We cloned this jira from CT-6283 to improve the performance of vyuCTGetAvailablePriceForVoucher as this will also affect the performance of the new Charges and Premiums feature for Grain.
*Steps* :
# Create Load In tickets with Contract Disribution.
# Distribute ticket.
# Check the http response time
*Main Issue* :
Took 20-30 sec to complete transaction
!pastedImage_d179348_0.png|height=534,width=557!
*Issue for this jira* :
This query inside uspCTCreateVoucher is taking almost 10 seconds. See [uspCTCreateVoucher.sqlplan|http://jira.irelyserver.com/secure/attachment/83609/uspCTCreateVoucher.sqlplan]
This contributes to the execution time of Load In Ticket Distribution.
!pastedImage_d179348_1.png|height=598,width=1229!
!pastedImage_d179348_2.png|height=192,width=1873!
*Acceptance* :
Improve the performance of vyuCTGetAvailablePriceForVoucher when filtering by intContractDetailId
|