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