- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content