For efficient batch processing with PDO, avoid OFFSET on large tables and instead batch by an indexed column (e.g. WHERE id > :lastId LIMIT 1000)....