Skip to Content
0
Former Member
Jul 07, 2009 at 02:26 PM

Portal Caching problem

25 Views

Hi Experts,

I have a workbooks with four queries running for business managers and this wookbook is on portal now.

I order to improve the performance of the portal, I have created IB jobs to store cachein the system.

Now the problem is cache is only working for individual business manager and not working for all managers.

There is a hierarchy on business managers (about 40), so different IB jobs can be set up for both of individual managers and totals.

The workbook has a big structure with defined cells (about 3mb).

It takes less than 2 mins to run this wookbook for individual managers in analyzer and portal.

It takes about 7 mins to run for all managers in analyzer and Information Broadcaster and it takes about 18 mins to run for all managers in Portal.

I tried to run trasaction "sm51" to check the process, it is "CL_RSR_REQ" under report column.

The portal performance for all managers is required to be reduced to below 2 mins.

Please let me know if you need more information.