Ticket #3916 (closed defect: fixed)
rindex entries aren't removed on object removal
|Reported by:||tdb01r||Owned by:|
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).