buffer table size

[Former Member]

Hi,

I read that in it's not recommended to use buffered table with size that largrer then 10 MB

,how can i calculate it ? i.e. how much records is 10 MB ?

Best regards

Michael

[Former Member]

Hi,

Buffering is generally done for tables which will contain lesser number of records and whose data will not change over a considerable amount of period.

Say for example the plants table T001W.

This is because the plant data will seldom change over a period.

Hence it makes sense to buffer this table because it will contain lesser number of data whihc is not going to change frequently.

If you table contains a large amount of data and which is going to change frequently say for example VBAK( sals order) then there is no point in buffering the table.

So it would depend on the functionality of the table whether to buffer it or not.

Hence check with your functional consultant the type of data expected in your table and then decide on the buffering.

If the table has a huge amount of data; then there is no point in buffering.

Regards,

Ankur Parab

[Former Member]

HI Ankur,

Thanks

The table is not change a lot ,90% from the access to the table is for read process,

And 10% is for update.

declare what is huge table ,how much records?

i want to use 3 tables for maintenance view and to make them buffer tables .

BR

Michael

[Former Member]

Hi,

I suggest you can discuss with your BASIS team regarding the table size needed so that buffer synchronisation is done properly.

Regards,

Ankur Parab

[Former Member]

Hi Ankur,

There is a way to calculate table size from records

for example 1000 records are 2 MB size or 3 MB ?

I need to know it for design perspective,to know if i can use fully buffered table.

Best regards

Michael

Edited by: Michael A on May 19, 2009 5:28 PM

[Former Member]

Hi Michael,

You can check the approximate size of each record in a table by totalling the size of all the fields. The memmory occupied in the system will however be larger.

What I would suggest is that you pick up some similar table(s), say x. Then analyse the table x using the report RSADAT6M already available. This should give you a very accurate picture of how much space will finally be occupied. This is a report supplied by SAP and calculates Table Sizes, Index Sizes etc.

Hope that this will solve you problem.

Regards,

Nimish

[Former Member]

HI nimsh

thanks

When i try ti use this report i get error :Program can be used only with MaxDB

do you have any idea what is the problem?

best regards

Michael

[Former Member]

Some databases make it very difficult to find the size of individual tables. Try using the transaction DB02. Some more options according to your installation should be found under

Choose Tools --> Administration --> Computing Center --> Management System --> Control --> Performance Menu --> Database

You can check this [link|http://help.sap.com/businessobject/product_guides/boexi/en/DIPerformanceOptGuide.pdf] too.