The query without using the batching SQL query parameters, namely order by id asc where id > ? limit 1000, seems to run pretty quickly and should avoid timing out. This change may result in the container hitting some memory issues, but that seems more manageable than trying to speed up the queries on these tables some more.
The query without using the batching SQL query parameters, namely
order by id asc where id > ? limit 1000
, seems to run pretty quickly and should avoid timing out. This change may result in the container hitting some memory issues, but that seems more manageable than trying to speed up the queries on these tables some more.