cancel
Showing results for 
Search instead for 
Did you mean: 

DesignStudio: How to speed up initializing of data sources ?

0 Kudos

Hello:

I have a couple of SAP BEx queries used in DesignStudio (old version 1.6) and noticed that the initializing of the data sources takes about 3.5 seconds (measured using &PROFILING=X), which IMHO is rather long.

How can I speed this up, or where can I look to see why the initialization is taking so much time?

Thanks in advance,
Andreas J.A.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi Tammy,

This is for the initial view, so no background processing there.
Parallel processing via processing groups is enabled already for the involved 5 Bex queries.

Also please do note, I am not talking about the actual query runtime (e.g. Fetch Result Set), but the initializing phase of the data sources.

The 3.5 sec. for initializing data sources applies when the dashboard is executed locally by the way. Executed on the SAP BI BusObjects server the initializing of data sources takes about 1.7 sec., which is more in line with what I expected.

I'd still like to know where to look/further measure and analyze the initializing phase of data sources.


Thanks.

TammyPowlas
Active Contributor
0 Kudos

Hello Andreas - have you looked at background processing or parallel processing to speed things up? https://archive.sap.com/documents/docs/DOC-64107