Report Performance

[KarunaTiwari]

Hi all,

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,

Karuna Tiwari

[Erik_Zencos]

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.

Regards,

Erik Meyer

[KarunaTiwari]

Thanks for your reply Erik!!