Buffering

[Former Member]

Hi,

i have one doubt .

How to decide whether buffering is allowed or not.

if it depends on number of hits on the database please tell the exact number.

thanks and regards

shoban

[Former Member]

Hi,

Goto to the tab TECHNICAL SETTINGS of the db table.There you can find whether buffering is allowed or not..

[SantoshKallem]

u can find it in technical settings.

mostly uses for master table(frequent use tables)

reward if useful

[Former Member]

Buffering is an option in technical settings while creating a table.

Usually We buffer a table which uses most and commonly used by all the people (both technical and functional).

Cheers.

[abdul_hakim]

Hi

Check the technical settings of the respective table in SE11.

Cheers,

Abdul Hakim

Mark all useful answers..

[Former Member]

thank to all

[Former Member]

Hi,

Buffering is required for increasing the performance of the database and the programs fetching the data. Buffering allows to save frequently accessed data, thus the program fetching the data need not directly fetch the records from database, instead it fetches the data from the buffer. This procedure increases the performance. Now the question is

<i>What happens if the data is changed frequently ?</i>

In this case, the data is read initally from database and after the first read, data is saved in the buffer. This procedure need to followed each the time the data changes. <b>Thus buffering is allowed when data is not frequently changed, but accessed frequently.</b>

check the blow links

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21f244446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21f26b446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21f29f446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21f2ac446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21f2d3446011d189700000e8322d00/content.htm

regards,

vara