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.
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.
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.