Opened 16 years ago

Closed 14 years ago

#252 closed enhancement (fixed)

Make the trashcan smarter when deleting items

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: trivial Milestone: BASE 2.4
Component: web Version: trunk
Keywords: Cc:

Description (last modified by Jari Häkkinen)

The trashcan now try to delete all items in one go, which means that it has to check if an item is in use or not. This check may require many queries to the database and if there are many linked item in the trashcan this process is timeconsuming. The worst case is that each iteration only deletes one item. Then the isUsed method is called for the other items many times.

A smarter approach would be to delete items in an order that is less likely to result in items beeing used when it is their time to be deleted. Ie. we should delete extracts before deleting samples, experiments before raw bioassays, etc. The worst case above could suddenly be turned into a best case where the isUsed method is only called once for every item.

See also ticket:577

Change History (8)

comment:1 Changed 16 years ago by Nicklas Nordborg

Type: defectenhancement

comment:2 Changed 16 years ago by Nicklas Nordborg

Priority: minortrivial

comment:3 Changed 15 years ago by Jari Häkkinen

Milestone: BASE 2.x+
Version: trunk

comment:4 Changed 15 years ago by Jari Häkkinen

Milestone: BASE 2.x+BASE 2.4

comment:5 Changed 15 years ago by Jari Häkkinen

Milestone: BASE 2.4BASE 2.3

Milestone BASE 2.4 deleted

comment:6 Changed 15 years ago by Jari Häkkinen

Description: modified (diff)

comment:7 Changed 14 years ago by Nicklas Nordborg

Status: newassigned

comment:8 Changed 14 years ago by Nicklas Nordborg

Resolution: fixed
Status: assignedclosed

(In [3526]) Fixes #252: Make the trashcan smarter when deleting items

Note: See TracTickets for help on using tickets.