Bank Account Register Not Loading-Performance Related

Issue No: GL-4709
Created 2/17/2017 9:46:37 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version TBD
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [- |http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=]   [HDTN-194072 - Bank Register Will Not Load|http://helpdesk.irely.com/iRelyi21Live/i21/#/HD/Ticket?action=edit&filters%5B0%5D%5Bcolumn%5D=strTicketNumber&filters%5B0%5D%5Bvalue%5D=HDTN-194072%7C%5E%7C&activeTab=&searchCommand=searchConfigAll1&searchTab=OpenTickets]   When trying to load the Bank Register for two of their three bank accounts it spins the loading screen for 1.5 minutes and then stops loading and shows a blank screen. On one account with ~3600 records, it is taking 13-14 seconds to load every time.     There must be a performance leak somewhere on this procedure. See video in commen     *Steps to reproduce:*   1. Cash Management > Bank Account Register > Select Bank Account *Issue:*   Selected Bank Account transactions did not display   *Acceptance:*   Should display transactions of selected bank account   Note:   Records of bank account was 100,000 plus and other bank account is 3,000 plus (which will load) and 30,000.