I have digitalized image hash, the hash is like 2k integers long. What's is the best solution to store it in database and search? Row count will be at least 3millions. Suggestions for performance? I'm thinking to create utf8_bin collation column and convert all digits to case sensitive hash and add index on the column, or is there any other better solution?
P.s. hash can be modified, 1k integers would be less accurate, so i prefer to store 2k or so.