mysql query

seby

is it possible to run a query every 10 - 15 minutes instead of everytime the script loads?

i was thinking about adding a timestamp to my table and comparing it with time() but that would still require a query, can i do this without running any queries? if so, any ideas?

thanx.

tasistro

you could use a file's date stamp as reference
or you could use the system clock to only run the query at the hour, fifteen past, half past and a quarter before the hour. of course all page requests at said minutes would run the query.

seby

Hmm, i didn't think about that, i think i like the system time better. thanx.

seby

Ok, this is what i came up with.. if anyone has a better suggestion please let me know, though this is a pretty simple accurate way to schedule a task to run..

thanx for the idea tasistro.

<?php

$update = array(15,30,45,60); // in minutes
$time = date(i, time());
$runtime = false;


for($i=1; $i<count($update); $i++) {  

if($time == $update[$i]){
	$runtime = true;
	}
}
if($runtime) {

// query to run .. or tasks

}

?>

tasistro

More compact

<?php

$update[15]=1;
$update[30]=1;
$update[45]=1;
$update[60]=1;

if (isset($update[date(i, time())])) {
// query to run .. or tasks
}

You can allways do a modulus operation on 15, on remainder 0 you have a winner. With that you can ditch the update variable and the isset call.

<?php

if ((date(i, time())%15)==0) {
// query to run .. or tasks
}

Which is even more compact.

barand

Watch out for script timeouts. You may have to schedule a job to call the script every 15 mins. and have the query run when the script loads.