Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hello Neal,
This is the main select command of my program:
SELECT * FROM cobk
WHERE kokrs = co_area
AND gjahr = year
AND vrgng IN s_btr
AND budat IN s_pdate
AND belnr IN s_docno
ORDER BY belnr.
SELECT * FROM coep
WHERE kokrs = cobk-kokrs
AND gjahr = cobk-gjahr
AND belnr = cobk-belnr
AND ( kstar IN s_accta OR
kstar IN s_acctm OR
kstar IN s_acctw OR
kstar IN s_accto )
AND bukrs IN compcode
AND wrttp = s_vtyp.
IF ( coep-objnr > 'OR' ) AND ( coep-objnr < 'OS' ).
...
| | | ---------------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
| | Popular White Papers
In the Spotlight  _.____.__ |
