At 09:01 2015-07-17, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Say I've got tables on a server that are "lookup" libraries, and by that, I mean the change somewhat infrequently. Instead of always searching those tables on the server, I'd like to pull them locally for faster processing---BUT I DON'T WANT TO PULL THEM EVERY TIME WHEN NOTHING HAS CHANGED. What's the best way to achieve this, trying to only update locally when something has changed on the server table? I was initially thinking looking at the CHECKSUM on the server table, keeping that locally in some sort of lookup table of its own, and only updating the local table when that checksum value is different. Now I don't want to get as granular (yet) as a row-by-row comparison, since these tables (maybe 10) will most likely have no more than a few thousand rows.
Why not check the directory date stamp for last modified? This is not perfect as someone could modify the file and then reset the last-modified datestamp (but that is stretching), or could somehow change the last-modified datestamp without changing the file (which would result in unneeded copies).
Sincerely, Gene Wirchenko _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
