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@gmail.com
On Tue, Sep 25, 2012 at 2:20 PM, Artur Fijałkowski wiki.warx@gmail.comwrote:
<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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l