on 06-18-2007 3:59 PM
what is the Runtime Buffer?
Hi
Everytime there is no need for the system to fetch the data from the database tables
During runtime it creates some temporary memory like thing and keeps that fecthed records in a Buffer like thing and next time when you try to fetch the data at run time first it checks for the run time buffer is there or not, if it is there it takes the data from that buffer, instead of bring from database
see the concepts of buffering
We have 3 types of buffering
There are the following types of buffering:
o single-record buffering
o generic area buffering
o full buffering
Single-record buffering should be selected when :
o For large tables where there are frequent single-record accesses (using SELECT SINGLE ...). The size of the records being accessed should be between 100-200 KB.
o For comparatively small tables for which the access range is large, it is normally advisable to opt for full buffering. Only one database access is required to load such a table for full buffering,
while single-record buffering calls for a very large number of table accesses.
And also check this matter.
Single-record buffering: Only the records of a table that are really accessed are loaded into the buffer
Single-record buffering should be used particularly for large tables where only a few records are accessed with SELECT SINGLE. The size of the records being accessed should be between 100 and 200 KB.
Full buffering is usually more suitable for smaller tables that are accessed frequently. This is because only one database access is necessary to load such a table with full buffering, whereas several database accesses are necessary for single-record buffering.
Check this link :
http://help.sap.com/saphelp_nw04/helpdata/en/f7/e4c5a8a84a11d194eb00a0c929b3c3/content.htm
Reward points for useful Answers
Regards
Anji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.