| Description |
Based on the DPA tool, there are blocking queries that are causing a considerable amount of waiting time in MCP last 8/25 around 3PM.
[http://dpa.irely.com/iwc/database.iwc?repo_id=1&db_id=3&iorw=r&day=Aug%2025!991629864000000&time=3PM-4PM!991629918000000&bc=&action=0&ts=3600&tab=53&pm=P&sdTab=&fullSQLText=&chartType=]
As per checking, the main cause of the slowness is the missing index in table *tblARPaymentDetail*
Executing the attached script ( [vyuAPBillDetail.sql|http://jira.irelyserver.com/secure/attachment/81447/vyuAPBillDetail.sql] ) in my local environment takes almost 10min to finish.
!pastedImage_d169246_0.png|height=679,width=1401!
*Issue* :
The script attached is taking almost 10min to finish
*Acceptance* :
Should be able to run the script in less than a second.
|