Fantastic news that this finally works. Thanks a lot, Carlos!
On Sat, 2017-08-05 at 23:27 +0200, Carlos Garnacho wrote: > Hi!, > > I've just been merged wip/carlosg/resource-leak-fix on master. For > some background, the URNs generated in the Resource table had no > clear > lifetime, so Tracker has been leaking those "on purpose" for quite > some time now. > > After a clumsy try that had to be reverted, some months ago I tried > to > address this using referential integrity across tracker tables. It > turned out correct, but too slow on certain situations (eg. deletes) > as checking that a resource could be deleted had to hit many columns > without an index. > > Philip OTOH suggested using a refcount and garbage collection > approach, which is what this branch implemented. I opted for managing > the refcount through triggers that increment or decrement the > refcount > in the Resources table, all these extra updates happen on rowid > matches, so it's significantly faster and more O(1)y than the > previous > approach. > > This branch has been lingering for some weeks now, but I've been > testing it since with no hiccups, and also caters for updating > existing databases. I think it's in good shape for merging before the > freeze :). > > Cheers, > Carlos > _______________________________________________ > tracker-list mailing list > tracker-list@gnome.org > https://mail.gnome.org/mailman/listinfo/tracker-list
signature.asc
Description: This is a digitally signed message part
_______________________________________________ tracker-list mailing list tracker-list@gnome.org https://mail.gnome.org/mailman/listinfo/tracker-list