topic Re: How to bypass buffer in Application Development and Automation Discussions

How to bypass buffer

Former Member — Wed, 18 Apr 2007 18:54:25 GMT

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 ???

Re: How to bypass buffer

Former Member — Wed, 18 Apr 2007 20:24:41 GMT

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.

Re: How to bypass buffer

Former Member — Thu, 19 Apr 2007 05:40:59 GMT

Hi Joseph,

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

Syntax :

SELECT ..................... BYPASSING BUFFER

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: How to bypass buffer

Former Member — Thu, 19 Apr 2007 05:43:27 GMT

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..

select *

from spfli bypassing buffer

into t_spfli.

regards,

sai ramesh

Re: How to bypass buffer

Former Member — Thu, 19 Apr 2007 08:42:37 GMT

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.

Using table buffering

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.

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

regards,

madhu