Question
igate global solutions
IN
Last activity: 1 Mar 2016 4:56 EST
Report definition vs RDB-List
Hi Everyone,
I have large volume of data say more than 10000 records to show in the portal.
So, to load the data either Report definition is good or just using a Connect-SQL with RBD-List will serve best.
Usecase:
I have a screen where this data to be shown, using report definition to get the data from DB which is a disaster in production. It has Maximum Elapsed Time in Seconds as 60 still it is not able to bring the data.
So, now I am thinking of writing a Connect-SQL rule with RDB-list and use that in the activity to get the data. Please suggest me which one is better.
Thanks,
Naveen
Pegasystems
IN
Did you find out why the generated SQL by report definition is performing so badly? A query plan should help identify is the issue is on the DB side or on the configuration of report definition itself.
igate global solutions
IN
The generated SQL looks good. The query is bringing data from a view and not table, and causing performance issue only when there is large volume of data.
Pegasystems
IN
So did you happen to check the query plan?
Also, how does the view perform for large data?
It would be great to engage your DBA to see if the view at the database level is performing good.