I made a command and registered it in Kernel.php named "offers:update". This command should do some changes on "offers" table depending on current status of each offer daily at 00:00. My "offers" table might have above 100,000 rows and i want to do changes in the the most optimized way.
I've read the documentation (v 5.8) and found chunk() method.
Is it enough or there is better idea?