How to bypass buffer

[Former Member]

I need to check the performance of the select statements

But the subsequent execution always is fast , bcos of the buffer read.

Kindly let me know how do i bypass buffer everytime.

The bypassing buffer doesnt work cos its the same as without it.

IS there a way to clear buffers either manually or by executing some other select query ???

[Former Member]

Hi,

You can use the SELECT... BYPASSING BUFFER addition to ignore the buufer every time you get data from a buffered table.

Hope this helps,

Sumant.

[Former Member]

Hi Joseph,

In the Select Stmt., use <b>BYPASSING BUFFER</b> to get the latest and updated data directly from the database server itself.

Syntax :

<b>SELECT ..................... BYPASSING BUFFER</b>

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

Hi..,

execute these two programs .., these are to clear the buffer !!

BCALV_BUFFER_DELETE

BCALV_BUFFER_DEL_SHARED

.............................................................

or in select statement itself u can use BYPASSING BUFFER statement !!

as..

<b>

select *

from spfli bypassing buffer

into t_spfli.</b>

regards,

sai ramesh

[Former Member]

Hi

sometimes to measure the program performance clear the buffer. go to ST10, then select the option "all tables" n then execute...then RESET it and execute your program. this you can do it...if you want to get consistent measurement of the performance.

<u>Using table buffering</u>

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

<i>Select distinct

Select … for update

Order by, group by, having clause

Joins</i>

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

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/f7/e4c5a8a84a11d194eb00a0c929b3c3/content.htm">chk this</a> for more details

regards,

madhu