-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Михајло Анђелковић:
WHERE rev_id > 0 AND rev_id < [...] AND rev_deleted = 0;
Please check that MySQL plans this correctly (using the rev_id index).
If this is generally allowed to do, my question is how large chunks of data can I take at once, and how long should be waited between two takes?
A simple fetch like this doesn't usually take many resources. You can probably pick any random number for chunking. If you run each chunk under SGE[0] as a separate job, and request an sqlprocs resource, SGE will handle scheduling for you so there's no need to worry about how long to wait between runs.
- river.
[0] https://wiki.toolserver.org/view/Job_scheduling