Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

deleting table contents via SQL painfully slow

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

Not what you were looking for? View more on this topic or Ask a question