Buffering of custom tables

[Former Member]

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

[former_member192616]

Hi,

sounds not like a buffering candidate to me. You'll find answers to your

questions here:

http://scn.sap.com/docs/DOC-26493http://www.sap-press.de/download/dateien/259/sap_press_pog_007.pdf

Kind regards,

Hermann

[jeroen_verbrugge2]

Hi,

Such big tables should not be buffered. Look why your performance on that table is bad by using SQL traces and change your code or add index where necessary.

Rgds,

Jeroen

[marcosmata]

Hi, Depends of what DB you have, you must check somethings like this:

1. The Z Table is in The Correct Tablespace?
2. The Z Table Primary Key is Correct?
3. The Z Table are getting accesed bypassing the Primary Key? Maybe 1 Secondary Indexe should be created, but be aware, by the size of the table 1 secondary indexes is enough.

You also may test a buffered scenario in your development or quality Server . Generic Buffer.

Greetings.

[Former Member]

Hi,

Yes, Large and frequently changed tables should not be buffered. Instead, check code for improvements and use indexes.