Hello,
I have a few tables that contain a large number of records ~200,000 in our ERP database, reading from these through a linked table has poor performance and even using a pass-through query my performance could be better. Performance from local tables seems to be the best, so I have created local copies of my linked tables using make-table queries. My question is this, is there any way to compare the data from my linked table to my local table and only update the changes? I have a macro to run the make-table queries to update my local tables but it recreates the entire local table and the performance is way less than desirable. Any ideas?
Thanks for any input.
- Jonathan