topic Re: RE:tables in Application Development and Automation Discussions

RE:tables

Former Member — Tue, 27 Nov 2007 12:18:22 GMT

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

Re: RE:tables

Former Member — Tue, 27 Nov 2007 12:20:22 GMT

Hi Alex,

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

Regards,

John.

Re: RE:tables

Former Member — Tue, 27 Nov 2007 12:22:10 GMT

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

Re: RE:tables

Former Member — Tue, 27 Nov 2007 12:24:07 GMT

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.