in reply to checking mySQL database for unique CRC32 as proxy for long string

How large of a string are you using here? Perhaps you might start with smaller strings while you figure the algorithm out. Also, at what point does it fault?

But God demonstrates His own love toward us, in that while we were yet sinners, Christ died for us. Romans 5:8 (NASB)
  • Comment on Re: checking mySQL database for unique CRC32 as proxy for long string

Replies are listed 'Best First'.
Re^2: checking mySQL database for unique CRC32 as proxy for long string
by diyaz (Beadle) on Jan 22, 2016 at 23:47 UTC
    about 7000 characters. I guess technically if I am manually checking if the item already exists then I don't need the checksum because I could just pull it to perl and check, but I guess checking a few bytes of binary is quicker than 7000char for each row.
[reply]

In Section Seekers of Perl Wisdom