It would be better, but I believe MediaWiki already uses this type of
storage. Changing to binary would require a schema change.
*--*
*Tyler Romeo*
Stevens Institute of Technology, Class of 2015
Major in Computer Science
www.whizkidztech.com | tylerromeo(a)gmail.com
On Tue, Sep 25, 2012 at 2:20 PM, Artur FijaĆkowski <wiki.warx(a)gmail.com>wrote;wrote:
<tl;dr>
Where an index is desired on a mysql column of base36 encoded
sha1
hashes, I recommend ADD INDEX (sha1column(10)).
Shorter indexes will be
sufficient in many cases, but this is still provides a >2/3 space savings
while covering a huge (2^51.43) space.
Isn't it better to store BIGINT containing part of (binary) sha1 and
use index on numeric column?
AJF/WarX
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l