Ticket #3916 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

rindex entries aren't removed on object removal

Reported by: tdb01r Owned by:
Priority: unset Milestone: 3.2.5
Component: - Version:
Severity: normal Keywords:
Cc:

Description

Removing an object won't remove it's entries in the rindex table resulting in that table growing unnecessarily.

Removing entries from rindex is also slow because the optimiser examines all entries for a given field: PRIMARY KEY(field,word,docid) Whereas it really needs: KEY(docid,field)

Not sure if the cost of having the key > cost of removals (which aren't very frequent).

Change History

Changed 3 years ago by tdb01r

Changed 3 years ago by tdb01r

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.