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?
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.