BYPASSING BUFFER

[Former Member]

I'd like to know if using the addition BYPASSING BUFFER in the SELECT statement it would affect the program performance. It would increase the response time of database access?

Thanks in advance,

Alberto

[Former Member]

Hi alberto,

Yes it would be a bit slower.

If you do not use that addition, it would keep the records that are fetched in a buffer , so that those records will be availlable for subsequent fetches.

If you give that addition, it would always hit the database which obvously takes more time.

Regards,

Ravi

[Former Member]

From the SAP HELP:

Disabling Data Buffering

If buffering is allowed for a table in the ABAP Dictionary, the SELECT statement always reads the data from the buffer in the database interface of the current application server. To read data directly from the database table instead of from the buffer, use the following:

SELECT... FROM <tables> BYPASSING BUFFER. ..

This addition guarantees that the data you read is the most up to date. However, as a rule, only data that does not change frequently should be buffered, and using the buffer where appropriate improves performance. You should therefore only use this option where really necessary.

Rob