PSJ - Performance enhancing

[Former Member]

Hello there,

I have developed a functio module which is using function module "LDB_PROCESS" with the LDB PSJ.

I have to reach data about budgets, actuals (both from COSS1 & COSSP1) and POC (from RPSQT).

When evolving large projects, the retrieval takes 5 times longer (!!!) than a retrieval done the "traditional way" (by accessing the data right through the tables).

I'm sure I did something wrong when I used the mentioned function module.

Is there anybody who can give me some clues?

Is there anybody who has used the mentioned function module with PSJ?

[Former Member]

Hi

LDB (Logical Databases) are quite conventional and are not suitable for large data retrieval and mostly create performance issues.

Therefore, idle approach is to go for a custom development and fetch the data , as per your requirement and use it accordingly.

But here if possible, you can view the Logical database using transaction - SE36 and look how the data retrieval can be made more effective in its program.

<b>Mostly select .. endselect statements, consume most of the database time. There, try to avoid those statements, as far as possible, and use internal tables to fetch the data once, and use the same locally, instead of again going to database server frequently.</b>

Ask in your team with the SAP ABAP Developers to suggest something from there end.

Hope this will help.

Pls reward suitable points.

Regards

- Atul

[Former Member]

I had a look at LDB 'PSJ' and it seems to be quite a big one. Since the requested nodes under a big hierarchy , all the nodes above the hierarchy are also requested implicitly . This is one of the dis when using LDB's. I guess a direct select stmt would be more efficient in this case.

[Former Member]

Hi Tal,

Actually the performance of LDB also depends upon how the parameters are being passed. for example, if the table is having key of fields f1, f2, f3. And you try to pass to value of some other field like f5 and then try to fetch data, then performance decreases significantly.

Secondly always try to pass the parameters of f1 and f2 while specifying parameters of f3. It will increase the performance.

Regards,

Navin