Buffering and Logging

[Former Member]

Can some one explain me Buffering and Logging concepts during defining the technical settings of Data Tables.

Thanks in advance.

Regards

Atahar

[Former Member]

Buffering : It is basically to buffer the table updates..in a temp space before it updates the database table.

Logging : It is basically to log the changes made to the table.

[Former Member]

Hi,

If you select Buffering the table contents are buffered and the select statements involving this table will first check the buffer before hitting the database table.

By logging i guess you mean Change Log, By clicking this checkbox you make it marked for recording logs when ever some data is changed at table level.

For more information on this hold the checkbox with mouse and press F1 you will get elaborate documentation.

Hope this Helps.

[Former Member]

Hello,

Buffering is more suitable for master data or config(customizing) tables. Tables which hold data that does not change often.

http://help.sap.com/saphelp_nw2004s/helpdata/en/c4/3a6dbb505211d189550000e829fbbd/frameset.htm

regards

[anversha_s]

hi,

<b>Buffering</b> : this helps to reduce the database access from the application server.

All the ,master data tables are buffererd. ie, if we accessed the master data table once for a certain time , it will be buffered in the application server.

so the next time no need to go to the data base server.

this will improve the performance

<b>

Logging</b> : It is basically to log the changes made to the table. ie, the lastupdation to the table,modification to th structure of table etc..so from tis we will get the history of table.

if hlped rwrd points

rgds

anver

[Former Member]

about Buffering:

its a memory area in server to store database values.(master data)

lets assume, you have some master data(in a table)and this data may have accessed by many people everyday. so to display the data to the user everytime system has to go to that table to fetch the values. this fetching is time consuming and increases network traffic. so to avoid this,what we do is,

when ever user requires any data first system will check its available in buffer or not,if not,then it will go to database and will fetch the records and display it to the user .at the same time this data will be added to the buffer for future use.

primarly, buffering concept is used for MASTER data.we can say data which is not changed soo frequently,we use BUFFERING technique for faster response.

Regards

srikanth