How to properly update records in a MySQL table based on data from an array?

Question

MySQL

Hello friends.
There is a question about the optimal algorithm for updating data in an existing MySQL table of goods from an array. The array is taken from a third-party resource in which both the cost, quantity, and other characteristics of an existing product change, as well as new products can be added. The number of records so far is about 1000 pieces. - a little, but maybe a lot more over time.
How to optimally solve this problem with the prospect of increasing the number of records in the table?

Answer 1

Loop through the array and update. There is an updateAll method, sometimes justified. Everything depends on the situation. It's not entirely clear what the problem is? You don't know how? Or don't know which option to choose? If the latter, please provide alternatives.

Answer 2

if you are not updating 1 million items, then solve it somehow. you will be doing premature optimization longer. there will be a solution, you will see the speed, then you will already understand what to optimize.