How to improve performance for Custom Extractor in BI..

[Former Member]

HI all,

I am new to BI and started working on BI for couple of weeks.. I created a Custom Extractor(Data View) in the Source system and when i pull data takes lot of time.. Can any one respond to this, suggesting how to improve the performance of my custom Extractor.. Please do the needfull..

Thanks and Regards,

Venugopal..

[former_member197561 · Accepted solution]

Dear Venugopal,

use transaction ST05 to check if your SQL statements are optimal and that you do not have redundant database calls. You should use as much as possible "bulking", which means to fetch the required data with one request to database and not with multiple requests to database.

Use transaction SE30 to check if you are wasting time in loops and if yes, optimize the algorithm.

Best Regards,

Sylvia

[Former Member]

Hi Reddy,

Did you check the transaction sbiw -> General settings -> maintain contro parameters

Here you can put the amount of processes we defined 4 and the extraction had a huge increase.

Regards,

Jurgen