Best way to create a table of checksums

Post Reply
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Best way to create a table of checksums

Post by barry.marcus »

I've got a table that has about 30 columns of large data, and the table has many rows. I'd like to create a companion table that contains, for each field/row in the data table, a checksum (i.e., using <hash>) of the data in the data table, where the structure of the checksum table matches the structure of the data table.

Any thoughts about the most efficient way to do something like this?

Thanks in advance.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Best way to create a table of checksums

Post by John »

For the actual processing a loop something like:

<sql row "select * from datatable">
<calchashes>
<sql novars "insert into hashtable ..."></sql>
</sql>
John Turnbull
Thunderstone Software
Post Reply