This content has been marked as final. Show 1 reply
1.) Caching is not a one-stop-shop for "solutions to everything".
2.) If you have a query that runs 3 hours you most likely have some poor design in you rpd and / or datasource.
3.) 10 minutes = fast response?
4.) Before starting to cache (see 1), analyze your problem. As I said it's most likely down to poor or just plain incorrect design. Check your business models. Then check your physical design.
Think fragmentation tables and / or aggregation tables. YOu get ten times more out of those (actually far more than 10x) than from caching.
5.) Examine using the Oracle OLAP option to create your segemtns off of a small cube (you might even want to look into cube materialized views if you have that option).
6.) If all this fails, come back here and I give you more info on caching.
Until 1-5 are done, don't ask for 6 ;-)