(PHP) list->mysql query iteration for cron job - cori

Mon, 23 Feb 2009 11:27:35 UTC

I needed to have a cron job that did some MySQL work iterating through a long list of items based on the content of a table in MySQL. I wanted each item in the table to be iterated over roughly once every 5 minutes, but building up the in-memory list of items to be processed based on the full contents of the table (~100 rows) was killing server memory and the process was dying. I wanted to find a way to, based on the time, only process a segment of the table's results, and to be reasonable confident that they would all be processed approximately every 5 minutes. Really simple problem, actually, but it took me a while to find the right logic...

(PHP) another (wp 2.3.3) custom loop query example - cori

Tue, 08 Jul 2008 13:26:51 UTC

(PHP) custom loop query example - cori

Sat, 26 Apr 2008 00:12:35 UTC

the above url has some helpful parameters

Snipplr

(PHP) list->mysql query iteration for cron job - cori

(PHP) another (wp 2.3.3) custom loop query example - cori

(PHP) custom loop query example - cori