I have a MySQL question.
I am calling a JSON API, which I can covert into 1,000 rows of data, e.g.
Let’s say I have these columns: id, ticker, title, description, price, info, date.
I need to update "price", "info", and "date" every 5 minutes from the API and if there are new rows I need to insert them into MySQL.
JSON data does not have the "id" in it, I am going to create it in MySQL. The only unique column in the JSON data is the "ticker". I need to have the id stay constant for each ticker as this data is being used in other places, so
I need to match up the "ticker" in the JSON file with the "ticker" column in MySQL.
I can call a PHP script every 5 minutes, so it’s not an issue but what about the rest? Do I do 1,000 updates and then INSERT IGNORE?