Let's pretend I wanted to store 1MILLION btc addresses in mysql,
I thought about saving the last 10 digits of each submitted address and testing against that but would 10 characters be enough to avoid duplicates? Is 10 digits too much? Or is there an even better way, does an industry standard exist?
Thank you in advance :)
It's not really clear what your use case is.
If you need to retrieve the addresses later, you can store each address as a string. That's only ~34MB, which easily fits in memory.
To save space, you can convert each address to hash160 format, which is only 20 bytes. In total, that's 20 MB.
If you're merely trying to test whether a Bitcoin address is contained within the database then you could use a bloom filter. A bloom filter with a false positive rate of 1 in 1020 and 1000000 elements would only take 11 MB.
