topic Re: By passing table buffer in Application Development and Automation Discussions

By passing table buffer

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

Hi ,

What is mean by by passing table buffer ? Why it is necessary ? Which statements can do this ?

Re: By passing table buffer

Former Member — Thu, 19 Apr 2007 08:44:09 GMT

Normally we will use this by passing buffer for T tables to optimize the fetching.

Use statement BYPASSING BUFFER in the select statement.

Eg:

SELECT persg " Employee group

persk " Employee sub group

trfkz " ES grouping for collective agreement provision

FROM t503

BYPASSING BUFFER

INTO TABLE i_t503.

Re: By passing table buffer

Former Member — Thu, 19 Apr 2007 08:45:17 GMT

Hi Kumar,

Use the Smt. BYPASSING BUFFER in the select stmt. to get the most updated information about the particular data directly from the database

Syntax :

<b>SELECT ............................ BYPASSING BUFFER</b>

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: By passing table buffer

Former Member — Thu, 19 Apr 2007 08:45:57 GMT

bypassing buffer on the select statement when you need the most up-to-date information, for example, select * from ztxtlfa1 bypassing buffer. Doing so causes the buffer to be ignored and the data to be read directly from the database. You should use this whenever you are reading for update, that is, reading a record that will be updated and written back to the database.

For example, in step D, if user 2 used bypassing buffer to read the record, the most up-to-date version of the record would have been read and user 1's changes would not have been lost.

Bypassing the buffer for updates provides the best balance between safety and speed. However, if you can be sure that all updates are done from a single application server, you don't need to code bypassing buffer. Bypassing the buffer does slow the update process a little because a database access is required. If you need the maximum amount of speed for updates, and if you can be sure that only one application server will be used, this alternative might work for you. Talk to your Basis consultant to find out whether it can be arranged.

praveen

Re: By passing table buffer

Former Member — Thu, 19 Apr 2007 08:47:30 GMT

In by passing table buffer, we are fetching the values directly from the data base,

not from the buffer.

select *..............bypassing buffer. this is the syntax.

Re: By passing table buffer

Former Member — Thu, 19 Apr 2007 08:54:47 GMT

what type of select statements by pass the buffer ? can any one give list

Re: By passing table buffer

Former Member — Thu, 19 Apr 2007 09:10:14 GMT

hi!

normally we will use it to optimize the fetching,

the buffer may not contain the updated data, in those times we will by pass the buffer.

Regards,

Indira.D