topic Re: BYPASSING BUFFER in Application Development and Automation Discussions

BYPASSING BUFFER

Former Member — Tue, 08 May 2007 21:26:35 GMT

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

Re: BYPASSING BUFFER

Former Member — Tue, 08 May 2007 21:30:25 GMT

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

Re: BYPASSING BUFFER

Former Member — Tue, 08 May 2007 21:34:44 GMT

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