topic Re: Performance large (condition) tables advice in Application Development and Automation Discussions

Performance large (condition) tables advice

erik_mulder — Mon, 20 Aug 2007 10:36:41 GMT

I am not sure if this is the right subforum for this, but thought this is the most suitable.

We are currently executing a roll out project integrating a new company

in our ECC 5.00 system in a existing client already used by 3 other

companies. We use a table (A950) in the system for storing general

sales prices (key: application/condition type/sales

organisation/distribution channel/material/end date valid).

MANDT

KAPPL

KSCHL

VKORG

VTWEG

MATNR

DATBI

DATAB

KNUMH

Currently the table holds 1,2 million entries. At the go-live of the

new company 3 new condition types will be added to the A950 table and

the table will then grow to hold approx.5-6 million entries. We expect

to add 3-4 million condition records for the new condition types.

We are concerned if this number of entries will significantly reduce

performance in pricing as we expect this table will be heavily

accessed as 1 of the added condition types will be needed during almost

every pricing determination for new sales orders/quotations.

Is it with regards to performance better to add the 3 new condition

types to (separate) new condition tables (We expect to add 3-4 million

condition records for the new condition types), so there is some

spreading of the load. Hope anyone has advice for us concerning this matter. Thanks in advance.

Kind Regards,

Erik Mulder

Re: Performance large (condition) tables advice

Jelena_Perfiljeva — Wed, 22 Aug 2007 20:01:27 GMT

You need to talk to your DBA and Basis about this.

Re: Performance large (condition) tables advice

Former Member — Mon, 12 Nov 2007 02:01:18 GMT

Hi Erik

Just wondering if you resolved your condition table performance issue. We are having similar performance issue on A915 table. Please let me know if you have any ideas or any information.

Thanks

jampalat

Re: Performance large (condition) tables advice

erik_mulder — Mon, 12 Nov 2007 09:09:44 GMT

We are not live yet, so we don't know for sure if there is gonna be a problem. We decided to split the condition types over separate tables to distribute the load.