Springboot scheduled tasks are executed every minute, operating the database, will it affect performance?

the task performed every minute is to query the data with a status of 1 from the database, and update the data (related tables) if it exists, otherwise it will not be processed, such a simple scheduled task, but will this execution per minute affect performance?

Mar.02,2021

get a database connection pool. The database link is basically fine.
also depends on the database data. Do not operate frequently if you have too much.
or separate the updated data from the data with a status of 1. Avoid too much data.


I'd better use python to run a scheduled task on the server

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e58cd2-454dd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e58cd2-454dd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?