What will be the best Data-type to store md5\sha1 hashes in MySQL?
Posted by: sandeep thakur
Date: February 04, 2015 06:24AM

I do have an application which extracts md5 and sha1 hashes from files and store them into DB. We've to maintain uniqueness on the bases of md5&sha1 and a lot of read operations are accessing the hashes. The data growth in tables will be huge. So what will be the best data-type I can choose storing the hashes. Should I go with binary type or varchar/char type. & how this can impact the performance.
Please not that that there are going to happen a lot of read & write operations.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
What will be the best Data-type to store md5\sha1 hashes in MySQL?
9138
February 04, 2015 06:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.