[Modin]

if you have shell access I'd recommend doing something this big via unix cron.

if you don't have shell access then batching is possible but would be tough. You'd have to write somewhere (either in the db or a file) saying how far a previous batch got so that you're not redoing queries. This opens up race conditions where you'd have to obtain a semaphore before starting... (A semaphore is a lock, if one process already has the lock then the next one who wants the lock will wait until the one holding the lock is finished.)

Something similar to this at the top of the batch file

PHP Code:

<?php
$mutex = sem_get(12345);

//grab the lock and only do actions if lock was successful
if(sem_acquire($mutex))
{
    $file = fopen("mark_file.txt", "w+");
    //read and write some marking data to a file
    fclose($file);
    
    //release the lock
    sem_release($mutex);

    //start queries based on acquired mark
}
?>