Table buffering

[rajkumar_kandula]

Hi,

Can any one tell me the purpose of buffering?

Types of buffering avialble for a table?

[Former Member]

Hi,

Table buffering is used to increase performance when reading data from database table. Data from a buffered table is read from a local buffer on the application server thus reducing database access.

There are three different types of table buffering that can be used in SAP:

Full Buffering : All Records of the table are loaded into the buffer when a record in the table is accessed.

Generic Buffering: All Records with the same key fields are loaded into the buffer when a record in the table is accessed.

Single Record Buffering: The specific record that was accessed is loaded into the buffer

[Former Member]

That is simple and perfect anser.

For mor information you can go through the help.sap.com.

You will get more detailed information.

Regards

Sandeep Reddy

[Former Member]

Hello

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f25e446011d189700000e8322d00/frameset.htm

[Former Member]

The table buffers lie in shared memory. There is a single-record table buffer TABLP and a generic/full table buffer TABL. The two table buffers differ primarily in how they manage free storage areas and in their displacement mechanisms.

Detailed information on the technical buffer structure, especially on the structure, access mechanism, displacement behavior, and global synchronization in distributed systems can be found in:

1. Single-Record Table Buffers

The single-record table buffer contains a central administrative structure, a table directory and the data area.

2.Single-Record Table Buffers

Generic table areas or full tables are managed in the generic/full table buffer TABL. The individual generic areas are managed in the buffer like autonomous, fully buffered tables.

Thanks and regards reeha