Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

what is table buffering ?

Former Member
0 Kudos

Hi guys

can any one tell me about the table buffering concept.

Thanks in advance

2 REPLIES 2

former_member233090
Active Contributor
0 Kudos

Hi,

Yes sure,

The aim of SAP table buffering is to buffer table contents on the application

server to reduce accesses of the database, thus conserving the database resources

(CPU load, main memory).

2)Records that are buffered on the application server can be accessed up to 100 times

faster than data in the database. As a result, the work processes on the application

server encounter shorter wait times, which means table buffering reduces the

load on the entire SAP system.

Records in the table buffer are saved sorted by the primary index.

3)We differentiate between the single record buffer (technically: TABLP), the

generic table buffer (technically: TABL) and the buffer for complete tables (full

table buffering). The single record buffer contains the records from the single

record-buffered tables. Physically, the generic table buffer contains the records

of the generically and fully buffered tables (this means that technically, both

buffering types use the same memory area on the application server).

cheers

bhavana

Former Member
0 Kudos

Moderator message - Welcome to SCN. However, please do some research before posting. Please read and [Asking Good Questions in the Forums to get Good Answers|/people/rob.burbank/blog/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers] Rob