What is the purpose of buffering? How many types of buffering?

Answer Posted / parthasarathi

Table buffering is used to increase performance when reading data from database table. Data from a buffered table is read from a local buffer on the application server thus reducing database access.

There are three different types of table buffering that can be used in SAP:

Full Buffering : All Records of the table are loaded into the buffer when a record in the table is accessed.
Generic Buffering: All Records with the same key fields are loaded into the buffer when a record in the table is accessed.
Single Record Buffering: The specific record that was accessed is loaded into the buffer.

Is This Answer Correct ?    46 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Control Break statements- At new...endat.

1130


How collect statement is different from append?

731


What are domains and data element? : abap hr

783


What are the types of the software component being deployed in the sap?

784


If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc

840






what is leave to TRANSACTION?

1206


What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why?

771


What is a type-pool?

854


Explain what are the various types of selection screen event?

785


What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr

886


What is runtime analysis?

797


Is it possible to run host command from SAP environment? How do you run?

807


Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?

757


What is sap abap tables?

804


What is a view in sap? : abap data dictionary

795