I'm trying to store a bunch of 512-bit SHA-2 hashes into a MySQL table. In an effort to save space, I'm looking to store them in binary form, instead of a string of hex digits. I'm also using ORM so this will inflate them to any object / structure I choose.
I know I could split them up using eight "BIGNIT" columns but that's too time consuming. I also thought of putting them in a single "BLOB" column but I heard they're slow to access. Could anyone offer some wisdom on this? How about "binary(64)?"
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!