topic Re: Buffering in Application Development and Automation Discussions

Buffering

Former Member — Tue, 26 Dec 2006 14:30:23 GMT

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

Re: Buffering

Former Member — Tue, 26 Dec 2006 14:35:33 GMT

Hi,

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

Re: Buffering

SantoshKallem — Tue, 26 Dec 2006 14:49:25 GMT

u can find it in technical settings.

mostly uses for master table(frequent use tables)

reward if useful

Re: Buffering

Former Member — Tue, 26 Dec 2006 14:56:35 GMT

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.

Re: Buffering

abdul_hakim — Tue, 26 Dec 2006 15:09:36 GMT

Check the technical settings of the respective table in SE11.

Cheers,

Abdul Hakim

Mark all useful answers..

Re: Buffering

Former Member — Tue, 26 Dec 2006 16:18:58 GMT

thank to all

Re: Buffering

Former Member — Tue, 26 Dec 2006 16:21:53 GMT

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