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

Menu