DDIC

[srinivasa_reddy5]

What is the use of Buffering?

When we go for Buffering

[Former Member]

Hi Srinivasa ,

Buffering in context to tables means that we store some records in the memory , so that when they are required for access later , we can access it from there instead of accessing the data base , so this helps in reducing access time.

Now buffering is set in such a way that the entire table is buffered ( all records are moved into the memory) , some records relatred to the current accessed record are buffered , and ony the selected record is buffered. See the three options given in buffering.

How we decide when to go for buffering :

It depends on the type of data stored in the table and the amount of data . By type of data i mean how frequently it is accessed , is it accessed mainly for read or frequent updations in also done , and so on

Regards

Arun

[former_member842213]

Buffer Tables on the Application Server

You can considerably reduce database access by buffering it in the application server table buffer. Reading a single entry from table T001 can take between 8 and 600 milliseconds, while reading it from the table buffer takes 0.2 - 1 milliseconds.

Whether a table can be buffered or not depends its technical attributes in the ABAP Dictionary. There are three buffering types:

· Fully buffering (100%): The first time the table is accessed, its entire contents are loaded into the table buffer.

Generic buffering: In this case, you need to specify a generic key (some of the key fields) in the technical settings of the table in the ABAP Dictionary. The table contents are then divided into generic areas. When you access data with one of the generic keys, the whole generic area is loaded into the table buffer. Client-specific tables are often buffered generically by client.

Partial buffering (or) single record: Only single entries are read from the database and stored in the table buffer.

[Former Member]

Hi ,

Suppose there are 5000 records in the transparent table and the necessity is that those records are to be updated .

In this case It will be better to move the records to the internal table ie., buffer and manipulate it Because fetching the records each and every time is tedious and takes lot of time .