Query Caching

[Former Member]

Dear Gurus,

Im having a problem running complex queries in the SAP EP. These queries were created in BWP and linked to the BW Web Application Designer (for Graphs) and were published as URL iviews in the portal (See Previous Post).

Apart from using aggregates, is there cany other way I can cache the queries ?

Regards

[Former Member]

Aggregates is a way that SAP BW has provided to cache queries.

But to enhance performance you can use the keep package of Oracle Database, if it is permissible for you to change things at database level.

If performance is an issue you also try and use the Partition of tables.

Thanks

Sanjoy Karmakar.

[Former Member]

Thanks

[Former Member]

Hi,

Just to clarify, query caching has nothing to do with aggregates. The query cache is a separate layer where the query results are buffered based on previous executions. The next time the query is run for the same selection critiera or a subset of the selection criteria (based on certain settings) the query result is read from the buffer and retreived almost instantaneously. In this case the data base read to either the aggregate or underlying infocube is avoided...giving you superior reporting performance.

In the opposite case, if the query is not cached, then there is a database read operation to either the aggregate or the infocube.

Hope that clarifies.