Queries in Batches

[fr600]

There's something I need to do, i.e. running queries in batches. There's a member table that contains like 200 rows. What I'm doing right now is, using FOR loop, selecting each row, running a complex mathematical equation for the row, and inserting new records to another table.

This is fine now since there's only 200 rows. If there are like 15000 members, this loop may cause trouble.

So I'm wondering how I can compute the equation taking 500 rows (1-500), reload the page for another 500 (501-1000), and so on... until it's done.

Is there any way I can do it? Or perhaps a class or something that would help me accomplish exactly what I'm trying to do here?

Thanks

[scrupul0us]

Why not used a stored proceedure and cron it?

[fr600]

scrupul0us;10987870 wrote:

Why not used a stored proceedure and cron it?

Because cron is disabled. 🙁

[awbrowni30]

How are you currently accomplishing this task? How often does the process need to run?

You could possibly array chunk based on the total number of members (i.e. if 10K members, then chunk by 500; if 15K members, then chunk by 1K).