Deletion in SapDB -
02-10-2004
, 09:03 AM
I've got SapDB database version 7.3 running on my linux.
Deletion of about 100,000 records ("delete all from...") takes about 15 minutes.
This also in turn deletes about 1,000,000 records in another table (cascade delete).
This kind of performance is unacceptable.
Is there anyway to speed up the deletion process (DROP TABLE is not an option)? |