GL Account detail - performance

Issue No: GL-3376
Created 4/3/2017 10:32:29 AM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 17.1
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!