Prior to Build 875, the Delete all only dleeted batched of records so had to be re-run several times on the object.
With the new version i did a delete on a Business Object that contains one attribute (not referenced) with 195000 records. After 30 minutes I cancelled and there were still 67,000 records left. There would appear to be something wrong with how this is processing ?
MSSQL
Delete All query
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
If you try to delete all records like this it will be very slow, because for every deleted record Aware IM will also try to delete all references to the deleted record and check and execute deletion rules.
If you know that your object has no references and no rules and you just want fast delete in the database you can write a plug-in that would do just that (we can do such a plug-in for you as well). We will probably also add a special action to do a "fast" delete.
If you know that your object has no references and no rules and you just want fast delete in the database you can write a plug-in that would do just that (we can do such a plug-in for you as well). We will probably also add a special action to do a "fast" delete.
Aware IM Support Team