Bypassing Buffering technique in sel. query

[krishna_k19]

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

[Former Member]

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

[krishna_k19]

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]

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]

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

Rob

[yuri_ziryukin]

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