July 3, 2002 at 5:34 am
Hi,
I was wondering if I can make use of checksum in a way to
improve my performance. Every end of day I get data
uploaded to my database, which I should reconcile with the
existing data. To do this I have to compare around 6 to 7
columns of different datatypes & lengths.
I think of storing checksums of both the tables overnight
and make use of them the next day to see if any of the
values in theses tables change. Will this work faster
than comparing the columns??
Also, will it help if I create a seperate database to
hold the uploaded data and then reconcile the data with
the existing data.
Any suggestions/feedback is of great help.
Thanks & regards,
Mitra
July 3, 2002 at 10:11 am
You'd have to test this. On the surface, I'd say yes, but the time creating the checksum may not outweigh the comparison time. SQL can be pretty fast at comparisons.
Steve Jones
July 3, 2002 at 12:47 pm
SQL does use checksums for comparing replicated tables, probably makes sense less data to move across the link. Agree with Steve that you'd have to test to see. Might also be a matter of looking at it from a different angle to find a better way to solve the problem.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply