Custom Table - Transactional Data - Design/Performance Tips

[Former Member]

Hi,

I have a Requirement to Insert/Update (Transactional Data) 500 times a day, the Custom Table. I have chosen the size category to ' 8 ' (Expected Records 4,500,000 to 9,100,000) the maximum limit given by SAP. I am sure this table will be storing/handling huge volume of records daily. Can any one please suggest me some Design/Performance Tips for creating a Custom Table in SAP.

Appreciate Your Help!

Thanks,

Kannan.

[Former Member]

Hi Kannan,

The size category for a table is not always constant.. This dependes on the record size of the table. The selection of the size category is very important step..

When you activate the table, depending on the size category, the system allocates a space in the table space for this table.. When this area is filled by the data, then another memory chunk of same size is allocated..

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**

[Former Member]

This creates a performance issue if you choose the incorrect size category, so that a number of memory chucks are used for the table..

In this case the system have to put extra efforts to link these memory locations and this impacts the performance..

Thanks and Best Regards,

Vikas Bittera.

**Reward if useful**

[Former Member]

Will your table only be updated in batch? Will it be read by on-line programs? You will have to think about indexes.

Also if you make the size category too large, it will reserve too much space and may impact other tables.

I would start off small and increase as necessary. If you forget, your DBAs will remind you.

Rob

Message was edited by:

Rob Burbank

[Former Member]

Hi All,

Thanks for all your Inputs.

Rob, This table will be available for read/update from SAP Custom Transaction as well as Portal Applications. Some times, It will be updated using batch programs. Please suggest me if you have any good solutions. I do not have much DBA exposure.

Appreciate all your help.

Thanks,

Kannan