topic Re: data base access in Application Development and Automation Discussions

data base access

Former Member — Thu, 24 Apr 2008 04:14:14 GMT

Hi Experts

while working with large no of records. which would be the better method to fetch data from the database . using select endselect with work area or fetching the data into internal table... which one will work faster?

Thanks

Lakshman

Re: data base access

Former Member — Thu, 24 Apr 2008 04:16:21 GMT

Hi,

If the records are exceeding more than 1 Lakh it better to go with work Area.

Reward iF Helpfull,

Naresh

Re: data base access

Former Member — Thu, 24 Apr 2008 04:17:55 GMT

Hi lakshman,

While fetching the records the better method is by using Internal Tables.

Select and endselect is also like a looping the table.

and also select endselect is obsolute.

Plz rewards points if helpful,

thanks & regards,

Ganesh.

Re: data base access

Former Member — Thu, 24 Apr 2008 04:20:00 GMT

Hi Lakshman,

If u have plenty of records then its better to get the Data in to internal tables first and process the internal table.

The Disadvantage of SELECT ENDSELECT is that it is a loop. For each and every record it hits the Database. Due to this the PERFORMANCE decreases.

the Efficiency depends on how many times we r hiting the database.

so if we use SELECT ENDSELECT, each and every time it hits the database to fetch the record. But where as in SELECT ... INTO TABLE <internal table> u hit the database only once and fetch all the required records and store in to ur internal table. Now u can process ur internal table for further operations

reward if helpful

raam

Re: data base access

Former Member — Thu, 24 Apr 2008 04:26:23 GMT

While fetching the data from the data base table being small number of data or large number of data it is always good and better practise to go on with the concept of work area.

As u need to fetch large number of records from the database table it is better and good to use work area for faster access

reward if useful

Re: data base access

Former Member — Thu, 24 Apr 2008 04:42:04 GMT

Hai,

It is always better to extract data into internal table.

Otherwise , if u are using only work area , if u want to use the data in the work area in furthur part of program , how can u use it? So, it is always better to use internal table to retrieve the data from database.

If useful, reward points.

Thank you

G.V.K.Prasad

Re: data base access

Former Member — Thu, 24 Apr 2008 04:56:24 GMT

Hi Laksham

Hi Lakshman,

Whether u hav few records or large number of records it always better to go for SELECT ... INTO TABLE <internal table> or workarea option becoz here u hit the database only once which determines ur performance also.

Also when u dnt use work area with select query or loop-endloop u get error/warnings in SLIN transaction.And the over all performnace issue increases.

Avoid using SELECT-ENDSELECT as for each record here the database is hit and the performance reduces drastically.

Hope ur confusion got cleared.

If any further query plz let me knw.

Kindly reward if helpful.

Re: data base access

Former Member — Mon, 19 May 2008 09:43:14 GMT

Hi,

Select and end select will cause performance issue

Due to hitting database table for several time. Using Internal table and workarea is better than select and End select.