Question
RABO BANK
NL
Last activity: 2 Dec 2015 10:29 EST
Slowness due to Heavy Data
Hi All,
My requirement :
On change , we have an "Activity" that brings 1000+ records and setting to a PageList, this Pagelist being referred to a Grid where user will have ability to select, filter the record.
Due to the records are more Grid gets stuck while filtering and not responding at all.
Kindly suggest my alternative approach.
Thanks
Suresh
Pegasystems Inc.
IN
Hi
Can you please check your logs and see whether you are seeing any error message or any ALERT entry there ? This should be the first step to debug the issue.
Secondly, I would like to know what is the behavior if you enable pagination ?
Last but not the least, what is the PRPC Version ?
RABO BANK
NL
For RD: I cant use RD since each row of grid have the check box to select the record
For Data Page: Data is dynamic here, it varies frequently so i may not use Data Page here.(Am new to Data Pages, correct me if am wrong)
Thanks
Suresh
Pegasystems
US
Here at Pega, we had a similar problem with displaying decision rules on the standard developer portal decision rule form, where if there were more than 500 lines in the decision rule, the grid was too slow.
The solution was to not even attempt to show the lines in a grid if there were more than 500 lines, but to instead let the user press the "export to excel" button on the rule form, which displays them more efficiently. The user can also modify the rows in excel and then when they exit excel, the decision rule gets updated with the modified rows.
You could design yours similarly, and even do a Pega trace of the decision rule form excel button processing to see how we do it.
By the way, we also include a dynamic system setting to change the threshold from 500 to another value, since in some environments the grid may behave better or worse depending on the hardware and memory. /Eric