Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
I presume you check your code with the code Inspector and/or SQL analysis (ST05).
Two hints:
- Do you read both tables using index support
- do you use Sorted or Hashed table types, or only standard.
Met vriendelijke groeten/ kind regards,
Ben Meijs
www.ctac.nl
| | | ---------------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
| |  Ben Meijs Ctac
SAP Development Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
