Batch Jobs from Unix Command Line?

[Anon]

I need to run a large batch job which will compare three tables (100,000+ records each) and create a fourth table from them. I want to use PHP and MYSQL but can not run a web script due to obvious time out issues. How can I do this from a unix command line with PHP3? Are there other options?

[khaine]

you could try running at a background job or change the timeout to a greater value.

something like

$result=prgname &;

the quotes are ` and not '

or change the timeout with

set_time_limit(time);

Mark