Buffering a table

Change your table's technical settings to use buffering by selecting the "Buffering switched on" radiobutton and then selecting "Fully Buffered" checkbox for buffering type. That will take care of it. All your programs will still be doing SELECT statements, but the system instead of going to the database all the time, will read from the buffer.

Hi Friend,

To buffer a table do following -

>>

Goto Technical settings of the table , Click on change mode, then

Click on Buffering Switched ON and choose appropriate form of buffering u require

from ---

• Single Record Buffering.

• Generic area buffering.

• Fully Buffered .

and click on save.

I will let u know about these 3 kinds of Buffering so that u can make idea which one u want to use----

The buffering type determines which records of the table are loaded into the

buffer of the application server when a record of the table is accessed. There are

the following buffering types:

• Full buffering: When a record of the table is accessed, all the records of

the table are loaded into the buffer.

• Generic buffering: When a record of the table is accessed, all the records

whose left-justified part of the key is the same are loaded into the buffer.

• Single-record buffering: Only the record that was accessed is loaded

into the buffer.

Hope this resolves ur issue,

Akash Rana