How does data fetching happens / optimized
in Webfocus ?
This relates to the architecture where the actual
database is RDBMS residing on different server.

When a large report is run by a user, is the data
cached for certain amount of time, based on any system parameters ?
( So any other user running similar query
gets fast response ) ?
How are cache parameters set and what level ( based on time frame/ session ? )

Nathan,

Just curious here. Most moderm RDBMS systems (Oracle, DB2, SQL*Server, etc) already provide very sophisticated caching/buffering support. Unless your answer sets are very large or your network is very slow, it's not clear to me that there is any significant advantage to re-caching data pages on the machine running WebFOCUS. And... if WebFOCUS is running on the same machine as your RDBMS, then I don't see any gain at all. Could you provide some more details?

Eric

Erich

I totally understand your point.
Unfortunately the person who manages the team
has good RDBMS/DBA background, but no BI tool
experience.

To my understanding Webfocus builds
dynamic query for each connection
and there is no caching on webserver of the output result set. i.e. one cannot set manually
cache size etc. for this purpose.

But wanted to make sure, since I have not
done sys admin type of function ( and now may
be required to do so ! )