Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Bypassing Buffering technique in sel. query

krishna_k19
Contributor
0 Kudos
701

Dear All,

          while fetching the data from few  tables its taking time , so i'm using bypassing buffer tech. (ex.SELECT RUECK RMZHL BUDAT WERKS GMNGA LMNGA XMNGA  AUFPL APLZL AUFNR VORNR
           FROM AFRU    INTO TABLE IT_AFRU
BYPASSING BUFFER ) so the query is some more fast shall i apply for all tables. if yes means then that time that table buffering techniques wil be switched on or not require . see the below screen shot

this is for afru table . Here buffering is not allowed then also if i write bypassing buffering query in select statement it will work or not is my doubt.

can any body elaborate this query.

Thanks......

Krishna

5 REPLIES 5

Former Member
0 Kudos
67

Hi Krishna,

If buffering is not allowed for the table then there is no any effect from using the phrase BYPASSING BUFFER. It is simply ignored

0 Kudos
67

K Thanks for ur reply..

     but i',m putting that query ten after its executing fast. but i'm not getting exactly what happening..

Thanks..

Krishna

Sandeep_Kumar
Product and Topic Expert
Product and Topic Expert
0 Kudos
67

As Tima commented if table is not buffered then Bypassing buffer has no impact.

krishna k wrote:

K Thanks for ur reply..

     but i',m putting that query ten after its executing fast. but i'm not getting exactly what happening..

Thanks..

Krishna

It depends on so many factors.. i/o, n/w lag, data selection etc...

Former Member
0 Kudos
67

You are labouring under a misapprehension - table buffering speeds up SELECTs.

Rob

yuri_ziryukin
Employee
Employee
0 Kudos
67

Clarification for topic starter:

a) Table buffering on the SAP application server side.

It is switched on in data dictionary in the technical settings for the table, as seen on your screenshot. This is normally done for the customizing tables that are relatively small and rarely changed (if at all).

BYPASSING BUFFER has effect on this buffering type. However, I do not recommend using this command. It makes only sense if your system is incorrectly configured and the generic/single record buffer size is set too small (see trx. ST02). But this should never be the case in a normal productive SAP system.

b) Database buffering.

This one takes place on the Database level. Data blocks of tables/indexes are buffered in DB cache and accessed from memory instead of disk. This buffer can be controlled on the DB level by the database administrator (change size, put a certain table completely into this buffer, etc.). And this buffering cannot be bypassed.

Regards,

  Yuri