How does sleep() work

[code green]

Does sleep hand temporary control back to the Operating System
or does it still demand the same resources as when the script is running?
Does it work the same way as VB doEvents().
I am updating data from mssql database to MySql on an overnight scheduled task.
I would like to wait a few secs to ensure the data has gone in,
then run a confidence check on the new data, emailing me of any problems.

[pbmods]

Heya, Code Green.

PHP's sleep() function essentially runs through an idle loop for n seconds. It doesn't release any memory, but it should not increase CPU load significantly.

[code green]

Merry Christmas pbmods.
Thanks. That is all I wanted to know.
sleep() will hang the PHP script but still use the same resources.
Nevertheless a query on a database will continue to execute within the DB engine.

[pbmods]

Heya, Code Green.

And a merry Chrismakwanzukk ah to you as well.

sleep() will hang the PHP script but still use the same resources.
Nevertheless a query on a database will continue to execute within the DB engine.

This is correct, however you'll have to help me understand your situation, because you shouldn't need to force PHP to wait until a DB query finishes executing. PHP will always wait for a DB query to return when you use mysql_query(), et al.

[code green]

A scheduled task runs a script stockAvailabilt y.php that produces a report of stock levels from a MySql database.
However, the beginning of stockAvailabilt y.php calls another script updateStockLeve l.php using exec().
updateStockLeve l updates the stock levels in the MySql DB from a MsSql DB.
I was worried that updateStockLeve l may still be running because it has been called by exec(),
while the first script compiles its report.
Or even the MySql engine was still updating.
My understanding of exec() is that it can run in the background.
So in my situation I have something like a multi-thread.

[pbmods]

Heya, Code Green.

I'm sure there is a good reason for this, but why exec() a PHP script rather than include() it?

I suppose what you could do is create a lockfile. Add something like this to the bottom of updateStockLeve l.php:

.
.
.
unlink('/path/to/lockfile');
 

And in stockAvailabili ty.php:

touch('/path/to/lockfile');
exec('php /path/to/updateStockLevel.php');
 
while( file_exists('/path/to/lockfile') )
{
    sleep(1);
}
 

[code green]

Thanks, pbmods I will study that technique.

I'm sure there is a good reason for this, but why exec() a PHP script rather than include() it?

Well updateStockLeve l is a standalone program that includes functions and classes that are common to stockAvailabili ty.
So I had function/ class redeclaration problems.