deleting table contents via SQL painfully slow

[Former Member]

Hi,

We are running SAP ECC on SUSE 9 Linux with Maxdb 7.6.6 - and

for the most part performance is not an issue.

I am trying to do a remote client copy which I am having problems with. It is taking forever to do the table coss .

in the target - the table has approxiametly 5,000,000 rows in the database, while the client target has at least 2,000,000+ rows.

By my rough calculations if I let the client copy do the delete ( before the insert ) it will take at least another two days just to delete the data.

I have tried to delete the contents directly via dbmcli as below

dbmcli on dec>sql_execute delete from sapdec.coss where mandt = '122'

but the session just times out after 60 minutes ( another issue ).

I am starting to look around the database but cannot see anything obivous.

Any suggestions of where to look would be greatly appreciated.

Thanks in advance

Gary

[lbreddemann]

Hi Gary,

you really should open a support message for this and have this investigated.

As you're on 7.6.06 it might be an option to activate prefetching for better table scan performance.

Anyhow, this should be checked in detail and this is not easy via the forum.

Therefore: support message.

regards,

Lars