05-04-2009 1:19 PM
Hi All,
Please provide me clarification on below issues :
1. If I replace FOR ALL ENTRIES by making RANGE on the required fields, Will there be performance improvement.??
2. Do use of range will have limitation on number of records that can be processed.(runtime error in case many records)???
Thanks in advance.
05-04-2009 1:26 PM
Hi:
it depends on the requirement, other wise For all Entries is the better options.
Regards
Shashi
05-04-2009 1:26 PM
Hi:
it depends on the requirement, other wise For all Entries is the better options.
Regards
Shashi
05-04-2009 2:05 PM
the range is faster at the beginning, because all lines are send in one block to the database.
But if the block becomes to large it will dump.
Therefore use the FAE, if you must process a variable amount of lines. Ranges is for manual user input, which are normally only a few.
Siegfried
05-04-2009 2:27 PM
Hi,
> 1. If I replace FOR ALL ENTRIES by making RANGE on the required fields, Will there be performance improvement.??
for very small number of lines in FAE (FOR ALL ENTRIES) driver table or range table - No.
Small in this case depends on DB type and SAP release ... could be 5, 30, 60 or anything else...
if number of lines is > 60 then RANGE could be faster since it is processed at once and not split like FAE (multiple DB calls)... BUT it could become too big regarding the length of the SQL statement...
> 2. Do use of range will have limitation on number of records that can be processed.(runtime error in case many records)???
Yes... there is a limit since a SQL statement must not get too long (depending on DB type and SAP release)... i don't have the current limits at hand... but it should be quite big.
When dealing with a bigger amount of lines... FAE is the better choice.
Kind regards,
Hermann