Description |
[https://sqlperformance.com/2012/07/t-sql-queries/running-totals]
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-196030 - 17.1 LIVE G/L DETAIL|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-196030]
On accounts with large data sets it appears that the
[http://irelyserver1.com/i21Source/i21/#/GL/GLAccountDetail?action=edit&filters%5B0%5D%5Bcolumn%5D=intAccountId&filters%5B0%5D%5Bvalue%5D=4%7C%5E%7C&activeTab=&searchTab=Transactions]
*try source for*
Account # 10003-0000-000
Date range 5/1/2016 to 5/31/2016
Quick Questions:
1) Buffered Grid?
2) Query issues?
3) Timeout
Expected result time
less than 2 seconds.
!pastedImage_d73603_0.png!
|