Skip to Content
0
Former Member
Aug 30, 2012 at 08:43 AM

Buffering of custom tables

260 Views

Hi Experts,

We have to buffer some custom tables having large amount of entries so that their performance can be increased. We will doing the changes in DEV client and then moving it through to PRD.

For this i have some queries:

1. We have a Z table having about 2 million entries in it. This table is updated after every 15 minutes with large amount of data and also data read/write is made from this table. Basically this is a control table.

Please suggest which buffer option to select?

1. Buffering switch on

2,. Buffering allowed but swiched off

Also which buffering type to select in this case?

Single buffering

Full buffering

Genric buffering

THe idea is when these changes will be moved to PRD then it should not create any issue in data read/write/update.

Also it will be nice to get a brief desciption on these options as well.

Regards

Gaurav Ranjan