Update about 1 million rows in MySQL table every 1 hour

Update about 1 million rows in MySQL table every 1 hour

jreklund
Administrator
Posts: 1,408
Threads: 3
Joined: Aug 2017
Reputation: 42

07-21-2020, 06:59 AM

By the looks of things you are executing (at least want to) one million + 1 query every hour. That's a lot. Depending on what you wan't to do with your data you need to rethink your structure.

1. Fetching/calculating only when needed
2. Run all calculations in SQL

Messages In This Thread

Update about 1 million rows in MySQL table every 1 hour - by olegrain - 07-21-2020, 01:20 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by jreklund - 07-21-2020, 06:59 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by olegrain - 07-21-2020, 07:27 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by ChicagoPhil - 07-22-2020, 01:01 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by jreklund - 07-21-2020, 08:35 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by php_rocs - 07-22-2020, 07:09 AM

RE: Update about 1 million rows in MySQL table every 1 hour - by John_Betong - 07-22-2020, 08:39 PM