Shorter checksum than MD5

From: Mercuro (this_at_is.invalid)
Date: 09/09/04 

Date: Thu, 09 Sep 2004 08:44:03 GMT

Hello

i'm looking for a simple way to checksum my data.
  The data is 70 bytes long per record, so a 32
byte hex md5sum would increase the size of my
mysql db a lot.

I'm looking for something that is 5 bytes long,
for the moment i'm just taking a part of the hex
md5 sum (like this: checksum = md5sum[3:8]). I
don't have any duplicates, and I have over 100000
records, but i'm not sure for the future...

Can anybody give me something better? Or point me
to some website?

thx!!

PS: I use this checksum to periodically compare 2
versions of this DB, which are on 2 sides of a
slow internet connection. My hope is to keep down
unneeded traffic between the 2 servers.

Relevant Pages

  • Re: major DNS hiccup
    ... So it probably isn't in the answers your bind gives as long as ... have a checksum, I wondered if packets were being truncated somewhere. ... Truncated packets should show up as such: IP keeps a length and the NIC ... point resolv.conf at ntl's servers instead of 127.0.0.1, ...
    (comp.unix.bsd.freebsd.misc)
  • Re: how tripwire is deployed?
    ... would TRIPWIRE be deployed on the gateway to the server ... If you're familiar with what TripWire is, you'll see that it must be ... deployed on the servers. ... checksum at a later date, and comparing it to the original. ...
    (comp.security.misc)
  • Checksum returns different number for same string on different servers?
    ... I used CHECKSUM on the first row in syscomments to detect differences ... in stored procs and user defined functions between databases/servers ... One of the "servers" is my machine and use a MSDE engine. ...
    (microsoft.public.sqlserver.programming)