topic Re: buffer table size in Application Development and Automation Discussions

buffer table size

Former Member — Tue, 19 May 2009 10:16:40 GMT

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

Re: buffer table size

Former Member — Tue, 19 May 2009 10:29:31 GMT

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

Re: buffer table size

Former Member — Tue, 19 May 2009 10:41:43 GMT

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 .

Michael

Re: buffer table size

Former Member — Tue, 19 May 2009 11:26:55 GMT

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

Re: buffer table size

Former Member — Tue, 19 May 2009 12:09:25 GMT

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

Re: buffer table size

Former Member — Wed, 20 May 2009 09:11:40 GMT

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

Re: buffer table size

Former Member — Wed, 20 May 2009 10:32:45 GMT

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

Re: buffer table size

Former Member — Thu, 21 May 2009 03:56:11 GMT

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.