hi

[Former Member]

regarding buffers? help please

[Former Member]

regarding buffers? help please

[Former Member]

hi kranthi.

buffers r the temporary memory area which will be available in ur application server

while ur creating table n if that table data is used frequently then that table will be assain buffers to it types of buffers r

single record buffers

full record buffers

generic buffering

while ur creating table in technical settings u will be assain the buffers

reward points if it is help ful

[Former Member]

We do buffering when we want to reduce the Frequent I/O from Applecation Server to Data base server, then we buffer the data on Application Server.

The buffering type defines which table records are loaded into the buffer of the application server when a table record is accessed. There are the following buffering types:

Full buffering: All the records of the table are loaded into the buffer when one record of the table is accessed.

Generic buffering: When a record of the table is accessed, all the records having this record in the generic key fields (part of the table key that is left-justified, identified by specifying a number of key fields) are loaded into the buffer.

Single-record buffering: Only the records of a table that are really accessed are loaded into the buffer.

If helpfull give reward point.