CODEWITHSUNDEEP
intersystems-iris
Jose Hellginton Cruz
Jose Hellginton Cruz

Reputation: 19

Purge strategy for parent-child persistent objects

We are seeing performance issues in purging objects/tables that have parent-child relationships defined. Due to the number of child objects, we're seeing a very long duration to purge a single parent and all child tables. Is there a better way to do this and get a more performant purge task?

I was thinking to purge the child tables individually first and then delete the parent is one way. Is there another approach?

Upvotes: 1

Views: 63

Answers (2)

robert.c.cemper
robert.c.cemper

Reputation: 181

"purge a single parent and all child tables". As you want to delete the parent too, it should be sufficient to delete just the parent object. By definition, all children should be deleted implicitly. BUT: most of the processing time may be consumed by the maintenance of all related indices.

Upvotes: 0

Evgeny Shvarov
Evgeny Shvarov

Reputation: 468

Try to delete the child objects via IRIS SQL. In this approach, you can see the query plan and maybe add the necessary indices.

Upvotes: 0

Related Questions