1 Reply Latest reply: Jun 3, 2009 8:29 AM by Lars Breddemann RSS

deleting table contents via SQL painfully slow

Gary Vaughan
Currently Being Moderated

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

Actions