05-04-2018 06:35 AM
I am creating similar kinds (not same) of Reports for 5 different Geographies.
What will be better in terms of Report Performance- Creating One table in EG for all the Geos and filtering the data in Reports or Creating 5 different tables and using them in 5 Reports??
PS - The data is huge for all the Geos and the Reports are taking considerable amount of time in Opening.
Thanks in advance,
05-04-2018 01:31 PM
Hi Karuna, you should do some testing first. If you create one big table in EG, and use a datasourcefilter in VA on the LASR table, and it takes more than ca 7 seconds to open a report (more than that, and the report users are going to be annoyed) you should create 5 smaller LASR tables.
I don't remember the source, but reasearh found about 7 seconds to be max for opening a report before users have a negative experience, so I always try to have that as my limit. The alternative then is to add more hardware.