I have an application "A" which is installed on over 100 different machines. In this application there is a table with around 400'000 articles. Each day these articles get updated on a different application "B". Now I copy the updated table from "B" to each installation of "A" and end up there with two tables (articles (old content) and master_articles (new content)). Then I want to update my articles table with the content of the master_articles. Of course I could just delete the content from articles and move all the content from master_articles into it. But is there some way to calculate the delta of these two tables and just (update the rows which changed / delete the rows which doesn't exist in master_articles / insert the rows which are not part of the articles table). It is just to get a better performance.
Thanks in advance for your answers