#2309 closed enhancement (fixed)

Committing a transaction with deleted items doesn't have to remove existing any-to-any links for all items

Reported by: Nicklas Nordborg Owned by: everyone
Priority: minor Milestone: BASE 3.19.10
Component: core Version:
Keywords: Cc:

Description

When deleting items, the commit action typically make some checks that no other items are using the item to be deleted and it also automatically issues SQL statements for deleting any-to-any links. This may take a long time if a lot of items are deleted. There are cases were this can be improved since not all items are actually "real" items, and it is very unlikely that they are linked to other items via any-to-any links:

  • Any-to-any links (what a mess that could be!)
  • File set members
  • Annotations, AnnotationSets
  • And maybe more...

In any case, there is also a background service that checks for stray links and it will remove them after a while.

Change History (1)

comment:1 by Nicklas Nordborg, 12 months ago

Resolution: fixed
Status: newclosed

In 8171:

Fixes #2309: Committing a transaction with deleted items doesn't have to remove existing any-to-any links for all items

AnyToAny links are now ignored for the following items:

  • Annotations
  • Annotation sets
  • Any-to-any items (!)
  • Biowells
  • Change history
  • Features
  • File sets
  • File set members
  • Reporters
  • Wells
Note: See TracTickets for help on using tickets.