topic Re: buffering in Application Development and Automation Discussions

buffering

Former Member — Thu, 07 Aug 2008 05:24:21 GMT

hi,

Can any one tell me what is buffering ?

and types of buffering and how they are working ?

regards,

vijaya.

Re: buffering

Former Member — Thu, 07 Aug 2008 05:26:46 GMT

Hi Vijaya,

Check this link:

http://help.sap.com/saphelp_nw04/helpdata/en/f7/e4c5a8a84a11d194eb00a0c929b3c3/content.htm

https://help.sap.com/saphelp_nw04/helpdata/en/f1/f5c2deca023d4bb7dfeaf5eda45307/content.htm

Regards,

Chandra Sekhar

Re: buffering

Former Member — Thu, 07 Aug 2008 05:26:54 GMT

hi,

There are many threads avaliable on SDN for this topic.

Search in the SDN first. You will find very good Material.

Regards

Sumit Agarwal

Re: buffering

Former Member — Thu, 07 Aug 2008 05:28:16 GMT

Buffering is a process used to synchronize the data flow btewneen a fast sender and slow receiver. A slow receiver stores that data in some temp. memory and use it to avoid data loss. It will boost up the processing speed.

Aditya

Re: buffering

Former Member — Thu, 07 Aug 2008 05:29:54 GMT

Hi Vijaya Lakshmi,

Sorry to say this..

Please search the forum first, if you dont find any answer, then post the question

Please check the forum...

Here are some of the links from forum

Best regards,

raam

Re: buffering

Former Member — Thu, 07 Aug 2008 05:30:43 GMT

Hi,

Buffering is method to store data in the application for further use.

For detail concept read the links serialy

https://help.sap.com/saphelp_nw04/helpdata/en/f1/f5c2deca023d4bb7dfeaf5eda45307/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f7/e4c5a8a84a11d194eb00a0c929b3c3/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f2b9446011d189700000e8322d00/content.htm

regards,

anirban

Re: buffering

Former Member — Thu, 07 Aug 2008 05:31:28 GMT

HI,

check the following link..

Regards

Sunil

Re: buffering

Former Member — Thu, 07 Aug 2008 05:31:35 GMT

there are 3 types of buffering

SINGLE RECORD BUFFERING : whenever a record is retrieved from the database using select single statement, the record can be buffered on the application server so that next time same query is fired, data can be retrieved from buffer itself.

FULL BUFFERING : whenever a select statement is fired, the entire table contents are transferred to the buffer

GENERIC BUFFERING : whenever a select statement is fired, a set of records is moved to buffer based upon the fields specified in the table for generic buffering. All records with same value for these fields are moved to the buffer.

Re: buffering

Former Member — Thu, 07 Aug 2008 05:32:18 GMT

buffer is nothing but a memory area. table is buffered means that table information is available on application server. when you call data from database table it will come from application server.

transperent and pooled tables are buffered. cluster tables can not buffered.

Buffering Type

three types of buffering are possible:

Full buffering

Generic buffering

Single-record buffering

Full Buffering

To activate the full buffering type, tickmark the Full check box. When an attempt is made to read data from a fully buffered table, the system looks in the TABL buffer for it. If it is not found there, all rows are loaded from the database into TABL . This happens whenever a select statement for it is executed, no matter how many records match the where clause. Even if no records match, all are loaded into the buffer if the table is not already there or if it has been invalidated due to buffer synchronization.

Generic Buffering

With generic buffering, a group of records is loaded into TABL instead of the entire table. To activate this type of buffering, tickmark the Generic check box and put a number n in the No. of Key Fields so that the n left-most fields of the primary key will group records. When a record is read and n is 1, all records having the same value in the first field of the primary key are loaded into the buffer. When a record is read and n is 2, all records having the same value in the first two fields of the primary key are loaded into the buffer

Single Record Buffering

Tickmarking the Single Records check box turns on single-record buffering. With this type of buffering, select single picks one record into the single record buffer TABLP, With this buffering type, records are only buffered when the select single statement is executed. Select/endselect does not load or read TABLP.

rgds

rajesh

Edited by: RAJESH KUMAR on Aug 7, 2008 11:05 AM

Re: buffering

Former Member — Thu, 07 Aug 2008 05:32:27 GMT

hiii

refer to following link for detail information

regards

twinkal

Re: buffering

Former Member — Thu, 07 Aug 2008 05:40:21 GMT

I would suggest you to use always SAP help first.

se11>give any table name>in display mode>tecnical settings>start press F1 on each radio button and check box and read.

you will get your answer.

Amit.

Edited by: Amit Gujargoud on Aug 7, 2008 7:40 AM