Archives of the TeradataForum
Message Posted: Wed, 25 Sep 2002 @ 08:14:10 GMT
| Subj: | | Re: Performance issue |
| |
| From: | | Doorey, Andrew ST |
2. If the same report run by more than one user(say 5 users) then the excecution time goes up.
Check the manuals and support site about report caching in Microstrategy. If the report and all objects within the report haven't been
updated and the users are all using the same database connection, database login and security filter then Microstrategy should only execute
the SQL against the warehouse once. This also happens even if the first run of the report hasn't finished yet - other users runs will use
the data from the first run.
You can trigger your most used reports to run outside of business hours so that the cache is available when your users start work and
reduce the load on teradata during the day, which could help.
Also Microstrategy is configured to use a maximum number of database connections. If, for example, you have this set to 2 and five users
try to run different reports Microstrategy will only run 2 at a time and the others will be queued. This may or may not be what you want,
depending on your business.
| 
