Efficient way to store hashes in database ?

[unix-ninja]

Encoding the hashes in base64 will not get you the fastest processing time for storage and retrieval. In-fact, it will hurt your stats for sure.

There are MANY factors to consider with MySQL, including the table engines, table structures, and usage of the tables and data.

If you want to gain a little performance in storage, don't convert the values to hex, use hex literals instead. For example:

Code:

insert into table (hex_col) values (0xHEXVALUE);

Additionally, depending on what this table will be used for and how the data will be used, you could try to optimize it by using memory tables to gain significant performance.

The thing to remember here, though, is that everything is relative.