Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
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
| | Most Popular White Papers
In the Spotlight  _.____.__ |
