Skip to Content
author's profile photo Former Member
Former Member

Buffering a table

Is there good way to buffer a table in memory. We have a control table which is accessed by many transactions. So indtead of reading from the transparent table, we want 2 buffer it such that all applications can read from it.. Is there a good way to do it?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Aug 14, 2009 at 08:49 PM

    Change your table's technical settings to use buffering by selecting the "Buffering switched on" radiobutton and then selecting "Fully Buffered" checkbox for buffering type. That will take care of it. All your programs will still be doing SELECT statements, but the system instead of going to the database all the time, will read from the buffer.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 15, 2009 at 02:26 PM

    Hi Friend,

    To buffer a table do following -


    >>

    Goto Technical settings of the table , Click on change mode, then

    Click on Buffering Switched ON and choose appropriate form of buffering u require

    from ---

    • Single Record Buffering.

    • Generic area buffering.

    • Fully Buffered .

    and click on save.

    I will let u know about these 3 kinds of Buffering so that u can make idea which one u want to use----

    The buffering type determines which records of the table are loaded into the

    buffer of the application server when a record of the table is accessed. There are

    the following buffering types:

    • Full buffering: When a record of the table is accessed, all the records of

    the table are loaded into the buffer.

    • Generic buffering: When a record of the table is accessed, all the records

    whose left-justified part of the key is the same are loaded into the buffer.

    • Single-record buffering: Only the record that was accessed is loaded

    into the buffer.

    Hope this resolves ur issue,

    Akash Rana

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.