I am unable to delete a namespace. Using either API code or the DTS Editor, my server reaches 99% cpu (with db process hogging it all) and essentially freezes up. This is with DTS4 under Jboss and SQL Server Enterprise Edition. Previously, I noticed that deleting even a small namespace - with nothing in it or with just 1 or 2 concepts in it - was taking around 10 *minutes*. The namespace I am trying to delete has perhaps 1-2 thousand concepts in it. Using the database diagnostic tools, the offending query appears to be:

DELETE FROM dts_defining_concept t, deleted d
WHERE t.concept_gid = d.gid OR t.superconcept_gid = d.gid;

Slight mistake. SQL Server says the long running query is:

DELETE FROM dts_defining_concept
FROM dts_defining_concept t, deleted d
WHERE t.concept_gid = d.gid OR t.superconcept_gid = d.gid;

Also, after about an hour and a half, JBoss kills the transaction, and although sql server appears to recover at that point, jboss seems to go into an unuseable state, meaning it does not respond to browser requests.

We are aware of this performance/functionality problem on deletion of Namespaces and are working to correct. In addition to MySQL support, performance improvement is a major focus of Version 4.1. In the meantime, we would recommend using the kbDelete batch file (found in ...\bin\kb\content\delete ) for deleting large Namespaces. A short "user guide" on use of kbDelete is attached.

1. The kbcontent-delete.xml file has some kind of bug in it (won't parse) so I had to remove all the connection info to make this work.
2. The app server appears to cache the namespace names; if I refresh the tree in a browser I continue to see the deleted namespace

It also took around 80 second to delete a namespace that consisted of just a single concept having a single property and no associations.