Solved: SLOW LDB Problem

Former Member · ‎01-28-2008

The program Ive been given to 'enhance' uses a logical database. I tried to argue that a 40 min response time was reasonable but they are not buying it. (we have to try right?)

Nearly 98% of the time used by this program is in database access.

I followed the generated code though using debug and there are areas that can be improved. But this is all SAP generated code of course.

Does anyone have any pointers on how I can 'copy and change' or even rebuild an LDB?

Former Member · ‎01-28-2008

why would you rebuild the LDB? There are other things you can do first.

Since you debugged the program already you know what tables are

accessed...

and possible keys (structure). Now I would investigate whether there are

any issues

with the table in the DB (e.g. ORACLE statistics out-of-date/wrong). Any

issues with

related buffers...

Then, knowing the keys and their structure check whether it is necessary

to create indexes

on the table(s) to allow faster access....

Then there are "hints" that could be set to allow ORACLE access tables

in a specific way...

I would look deeper into those possibilities than trying to rebuild a

LDB....

regards,

satish.

Former Member · ‎01-28-2008