MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
What will be the best Data-type to store md5\sha1 hashes in MySQL?
8968
sandeep thakur
February 04, 2015 06:24AM
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
3785
Rick James
February 05, 2015 06:57PM
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
2345
sandeep thakur
February 11, 2015 01:33AM
Re: What will be the best Data-type to store md5\sha1 hashes in MySQL?
1957
Rick James
February 12, 2015 12:13AM


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.