THERE R 3 TYPES OF BUFFERING FOR A TABLE:-
1. Full table buffering :- here entire database table buffered to application server.
So further access to same table can be access from application server so, which interm reduces database traffic.
Fullbuffering can only applies to tables which have less data and rarely changed.
Ex-tcodes, company master data like T100, etc
2.Single record buffering:- here only one record can buffered to application server by select single…………… with where all key fields can be specified .
Here if no record exists then also no record information stored to application.
Here it applies to database table which is larger in size and modified frequently.
3. Generic buffering:- here few database table records which matches can buffered to application server depends on generic keyfields(key fields specified while setting buffer settings).
So further access to same table can be access from application server so, which inters reduces database traffic.
Full buffering can only applies to tables which have less data and rarely changed.
Ex-tcodes, company master data like T100, etc
1. Full table buffering :- here entire database table buffered to application server.
So further access to same table can be access from application server so, which interm reduces database traffic.
Fullbuffering can only applies to tables which have less data and rarely changed.
Ex-tcodes, company master data like T100, etc
2.Single record buffering:- here only one record can buffered to application server by select single…………… with where all key fields can be specified .
Here if no record exists then also no record information stored to application.
Here it applies to database table which is larger in size and modified frequently.
3. Generic buffering:- here few database table records which matches can buffered to application server depends on generic keyfields(key fields specified while setting buffer settings).
So further access to same table can be access from application server so, which inters reduces database traffic.
Full buffering can only applies to tables which have less data and rarely changed.
Ex-tcodes, company master data like T100, etc
No comments:
Post a Comment