I have a table named 'establishment' which has a join with a table 'category' and a table 'product'. I added indexes to foreign keys to enhance the execution time of the update or delete of data. I have to update the table establishment when I get a new data received from an external api. The amount of updated data is about 3000-5000 rows.
I used an update query to update the modified rows, however when I search on the net I found that some people said that update is cpu intensive consumer and delete+insert is faster.
I didn't make any test for the performance between them and I want first of all to know if the update consumes more cpu in case of a large amount of data and with table with join.
