Click here to Skip to main content
15,923,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am working on a project in which I am importing data from several foreign data sources (i.e. sybase, foxpro, etc.). Rather than processing each record as if it has been updated, I am looking for some advice on how to determine if the record has changed prior to collecting all of the data from the source and going through all of the processing steps that are required... Some of the tables have upwards of a million rows and each row requires a lookup in the production table. I had originally thought of using a hash value... collecting all of the data from the source then computing a hash value, and comparing the hash in the production table to the one generated. If different, then update, else move on. From the research i did, it does not appear that the hash will be the same each time it gets generated.. Any help would be great!

Thanks!

Craig
Posted

1 solution

You could look in to the audit trail:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sag1/html/sag1/sag1864.htm[^]

I don't know anything about foxpro but I guess there is some audit trail there as well.

Good luck!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900