topic Re: Re: Bypass Buffering in Application Development and Automation Discussions

Re: Bypass Buffering

Former Member — Sat, 13 Jan 2007 16:13:06 GMT

Hi Experts,

please let me know clearly that what bypass buffering and we have one

parameter in REUSE_ALVE_GRID DISPLAY so how it is usefull.

2) If there is a need to extract millions of record from the database so how

to design select statement.Is there any specific key need to specify in

select statement.

thanks

sana khan

Re: Re: Bypass Buffering

Former Member — Sun, 14 Jan 2007 09:32:03 GMT

Use of buffered tables is recommended to improve the performance considerably. The buffer is bypassed while using the following statements

Select distinct

Select … for update

Order by, group by, having clause

Joins

Use the Bypass buffer addition to the select clause in order to explicitly bypass the buffer while selecting the data.

Ex.

SELECT kokrs kostl BYPASSING BUFFER

INTO TABLE gs_cskskey

FROM csks

WHERE bukrs EQ p_bukrs

AND kokrs IN s_kokrs

AND kostl IN s_kostl

AND datbi = sy-datum

AND bukrs IN s_bukrs.

2. Use the SELECT SINGLE option.

PLZ REWARD POINTS

Re: Re: Bypass Buffering

Former Member — Sun, 14 Jan 2007 13:10:46 GMT

Hi sana,

if you do not use bypass buffer, the SELECT statement always reads the data from the buffer in the database interface of the current application server. the above things will be done only if buffering is active on the table.

coming to select statements....

it is always advisable, to do array fetch using the primary keys.

select (col1) (col2)... from <table> to itab

where <primary key>

or if not possible to give all primary keys, then atleast

create a secondary index on the fields which you are giving in the where condition.

regds,

kiran