Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

RE:tables

Former Member
0 Kudos

Hi all,

On what reason table is decided to be single record or full table record buffer or generic record buffer in technical settings for a table.

Regards,

Alex

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Alex,

It depends on the size of the table and change frequency of the records buffered.

Regards,

John.

3 REPLIES 3

Former Member
0 Kudos

Hi Alex,

It depends on the size of the table and change frequency of the records buffered.

Regards,

John.

Former Member
0 Kudos

<b>The buffering type defines which table records are loaded into the buffer of the application server when a table record is accessed.</b>

There are the following buffering types:

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

<b>Generic buffering</b>: 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.

<b>Single-record buffering</b>: Only the records of a table that are really accessed are loaded into the buffer

Former Member
0 Kudos

oh well, assume a table with 10 million records e.G. MARC, you do NOT want to buffer them all, unless you got some hundred terra byte RAM.

so in this case you dont buffer because it wont work, or if it will work the performance of the rest of the system will suffer.

if you have a table which is beeing used/changed 2 times a year, you dont NEED to buffer, since at those 2 times it doesnt matter if it takes a second or 10 seconds.

those are 2 ideas behind it.