Why would you do that? HashKeys and HashDiffs are binary generated using a hashing algorithm like MD5 or SHA-1. Just store them as binary and effectively halve your storage and double your I/O! No need to convert them to the Char to store them as Varchar.
Showing posts with label binary. Show all posts
Showing posts with label binary. Show all posts
Wednesday, February 23, 2022
Anti-pattern: Using varchar to store the HashKeys and HashDiffs
Subscribe to:
Posts (Atom)