Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Dear ,
Of course Select for all entries is far better than single selects in a
loop.
But you should be very cautious while using select for all entries.
Points that you should take care of are :
1) Always check that internal table of which you are using select all
entries should
not be initial. if it is initial it will go in table to fetch all the
data which will take a very long time
2) The database table from which you are selecting entries, make sure you
are
fetching all the primary key part, whether required or not else some
of your
entries might remain missing.
take care of the above facts and your program performs far better...
Happy Coding !!!!
Shairry
From: "rinikalsi via sap-dev" <sap-dev@Groups.ITtoolbox.com>
To: Shairry email@removed
Date: 07/02/2010 10:01 PM
Subject: [sap-dev] Performance of Select for all entries
Related Content
White Papers
12 Criteria for Selecting the Best ERP System Replacement
Posted by rinikalsi (Miss) Business Intelligence: Actionable Insights for Business
on Jul 2 at 12:16 PM Decision Makers
More White Papers...
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for
hi all , IT. Gain Points for Community Achievements
View this thread online
I need a small suggestion from all SAP gurus . Manage group e-mails
My query is as follows Create an FAQ on this topic
I have multiple amount of data and for each set of data i Tell us what you think
have to push a select query Unsubscribe from discussion
Presently I am looping the whole data and putting it in an _.____.__
internal table
And finally i am using that internal table to push the
select query using select for all entries.
Hence wherever I have to push the select query , I am using
select for all entries.
But for this I have to loop all the data initially and put
it in a temporary table .
So in order to avoid single select queries , I have to loop
all the data and pt it in atemp table.
Can anyone please suggest which is more effecient in the
above case . Pushing select query everytime
or looping the whole data and then pushing select for all
entries .
Thanx in advance.
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
