Difference between buffering types

[Former Member]

Hello,

What is the difference between Buffering not allowed and Buffering allowed but switched off?? SAP recommends to unbuffer certain tables in order to increase the performance. Which option i have to choose? Please help me to choose the correct option.

Thannx in advance..

Regards,

Vishukumar M.

[Former Member]

Dear Satish,,,

You must define whether and how a table is buffered in the technical settings for the table. There are three possibilities here:

Buffering not permitted: Table buffering is not permitted, for example because application programs always need the most recent data from the table or the table is changed too frequently.

Buffering permitted but not activated: Buffering is permitted from the business and technical points of view. Applications which access the table execute correctly with and without table buffering. Whether or not table buffering will result in a gain in performance depends on the table size and access profile of the table (frequency of the different types of table access). Table buffering is deactivated because it is not possible to know what these values will be in the customer system. If table buffering would be advantageous for the table size and access profile of the table, you can activate it in the customer system at any

Cheers

fareed

[Former Member]

Hi,

Buffering, means whether you can buffer the entire database table data into ABAP memory.

Buffering is only recommended when the tables have less data and less columns are there, that is for small sized table buffering is preferred.

Some tables buffering is not allowed at all. And in some tables buffering is allowed but switch off at the moment we can do the buffering if we want in the program.

[GauthamV]

Check this documentation

[http://help.sap.com/erp2005_ehp_04/helpdata/EN/cf/21eaec446011d189700000e8322d00/frameset.htm]

[Former Member]

Thank u all for your helpful comments..