Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi
Use hashed tables to read cobk and coep. they are faster.
your guess is right: the more records you read the more time it takes to insert them into an internal table (just run tcode ABAPHELP with standard table and read that help...there used to be a pretty good explanation of how an itab works and why it can have performance issues there ... ) . Furthermore, every row you insert into a standard table needs more time than the previous one...(of course the time needed is small really small... but just imagine you need 0.005 secs to insert a row... 2000000 rows would need 2000000 x 0.005 = 10000 seconds
another thing you could do is check the logic of the join (nested loops are easy but they can be a real pain if they hold a huge number of rows...)
HTH
Horacio
PS. an snippet of your code, and the itabs structure is almost mandatory if you want more help
| | | ---------------Original Message---------------
From: a-parsi
Sent: Tuesday, April 05, 2011 5:09 AM
Subject: Custom report performance
Hello everybody,
I have a custom report which is very slow. It takes about 14 hours to retrieve data from cobk and coep. cobk contains more two million records and I cannot find the number of records in coep. In development environment with 9000 cobk and 40000 coep records, it generates the output in less than two minutes.
Somebody had told me that if I use internal table to retrieve records with ne command and not touch database for each record it will work faster.
I changed my report but its performance has not changed in development environment. Does it make any difference for more records? I mean is any explanation about the performance of these two methods according to number of records? |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  horacio zapettini
SAP Development Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
