Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Can you give us a snippet of your select and any looping, so that we might
better help you...
Neal
| | | ---------------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
| |  R. N. Wilhite
SAP Development Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
