Logical Dbase Performance

[former_member426550]

hi fellow programmers..

i developed a payroll program which work fine at the development server..

upon transport to QAS server..i noticed that the program is not performing well when dealing with large number of data..

i also tried running it with minimal data(2K records) at qas server and works fine since i applied most of the performance tunning guide...

is there any way to prevent this?when i debug it i found out that for 1-3k records the program is doing well, but upon reaching 4k records above, the program is running slow.

my plan is to divide the data by 2k so that from start of execution to finish, the program will run fast...

any other approach?or any suggestions?

thanks for reading..

[MarcinPciak]

Hi,

PY extraction data is long lasting process. If you run it for so huge population it will extend even more. I usually don't bother how long it will take (someone else will run it anyway;) ). Normally user can provide not the population itself but PY area or personal area instead (so the report would run couple times but faster).

What is to be noticed here is that you may reach timeout as run time will be too long. I suggest to use FM SAPGUI_PROGRESS_INDICATOR in order to avoid such situation.

Regards

Marcin

[former_member426550]

hi...

what i did is create another program then used submit.

get pernr.

add 1 to ctr.

gt_pernr-low = p0001-pernr.

append gt_pernr.

if ctr eq 30.

submit payroll with gt_pernr.

endif.

by doing this was able to control the payroll program to process 30 employees only ...

save running time by 20-30 percent..

[former_member426550]

Solved by using batch processing