On 11-09-19 11:43 PM, Domas Mituzas wrote: >> * When reverting, do a select count(*) where md5=? and then do something >> more advanced when more than one match is found > finally "we don't need an index on it" becomes "we need an index on it", and > storage efficiency becomes much more interesting (binary packing yay ;-) > > so, what are the use cases and how does one index for them? is it global hash > check, per page? etc > > Domas One use case I know if is this bug: https://bugzilla.wikimedia.org/show_bug.cgi?id=2939
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://daniel.friesen.name] _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
