topic Re: Difference between buffering types in Application Development and Automation Discussions

Difference between buffering types

Former Member — Mon, 01 Jun 2009 05:11:14 GMT

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.

Re: Difference between buffering types

Former Member — Mon, 01 Jun 2009 05:15:47 GMT

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

Re: Difference between buffering types

Former Member — Mon, 01 Jun 2009 05:17:07 GMT

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.

Re: Difference between buffering types

GauthamV — Mon, 01 Jun 2009 05:17:27 GMT

Check this documentation

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

Re: Difference between buffering types

Former Member — Mon, 01 Jun 2009 05:32:16 GMT

Thank u all for your helpful comments..