topic Re: buffering in Application Development and Automation Discussions

buffering

Former Member — Wed, 27 Dec 2006 06:29:40 GMT

Hi,

Please tell me on which criteria we allow buffering to a table.

regards,

Shoban

Re: buffering

Former Member — Wed, 27 Dec 2006 06:32:50 GMT

check this

Regards

Prabhu

Re: buffering

Former Member — Wed, 27 Dec 2006 06:33:35 GMT

Check this help:

Buffering status

Definition

The buffering status specifies whether or not a table may be buffered.

This depends on how the table is used, for example on the expected volume of data in the table or on the type of access to a table. (mainly read or mainly write access to the table. In the latter case, for example, one would not select buffering).

You should therefore select

- Buffering not allowed if a table may not be buffered.

- Buffering allowed but not activated if buffering is

principally allowed for a table, but at the moment no buffering

should be active. The

buffering type specified in this case is only

a suggestion.

- Buffering allowed if the table should be buffered. In this

case a buffering type

must be specified.

The buffering type defines whether and how the table should be buffered.

There are the following types of buffering:

single-record buffering

generic area buffering

full buffering

In generic area buffering, a number of key fields between 1 and no. of key fields-1 must be specified.

Re: buffering

Former Member — Wed, 27 Dec 2006 06:34:28 GMT

Hi,

Check this,

http://help.sap.com/saphelp_nw04/helpdata/en/aa/4734a00f1c11d295380000e8353423/content.htm

Regards,

Balaji Reddy G

Re: buffering

Former Member — Wed, 27 Dec 2006 06:35:11 GMT

Hi Shweta,

Buffering concept for the table depents on the number of hits on that custom table.

That means..how much amount of the informatoin that the user going to retrive in one single hit from the database.

and some tiems it will depents on the hit ratio ~~That mean~~> how frequent the data is going to retrive from the database.

Regards,

Sunil..

Re: buffering

Former Member — Wed, 27 Dec 2006 06:38:25 GMT

Hi Shweta ,

buffering to a table is allowed based on how and at what frequency the data is retreived from thr table.

the basic idea of buffering a table is to reduce the time required to access the data from the table.

Buffering can be done in 3 ways , in the first case the record that has been retrieved will be buffered so that nect time when the user tries to access the record it takes less time , second case moves with the assumption that tne records next to the currently selected records will be accessed next , so records related or next to the currently selected records are bufferd and the third option is the entire table is buffered.

Things to keep in mind when buffering are as follows.

1. Volume of data in the table : It is not advisable to buffer the entire tables which have very large volume of data.

2, How frequently is the data updated in the system : Suppose the data in the table is updated frequently , then there can arrise a situation when data in buffer and one in table are inconsistent.

There are few other criteria's which come into play when you deicde to buffer a table or not.

Regadrs

Arun

Re: buffering

Former Member — Wed, 27 Dec 2006 06:40:40 GMT

U need table buffering when u require data from that table repeatedly..i.e when number of reads are more to that table. At the same time you have to ensure that table size is not bigger. Also table shouldn't be updated frequently, b'coz if u get data from buffer it may not be relevant to that time. Ideal table to be buffered are master tables.

for more info, follow the link below and search for table buffering

http://help.sap.com/saphelp_46c/helpdata/en/cf/21ea0b446011d189700000e8322d00/frameset.htm

regds

Sreenivasa Reddy V

Re: buffering

Former Member — Wed, 27 Dec 2006 08:28:30 GMT

thanks to all