[kronolith] reminders.php very slow

[Chris St. Pierre]

I'd like to use kronolith/scripts/reminders.php to send out alarm
messages to my users, but running the script takes about 10 minutes
and consumes significant amount of resources.  Is there any way to
speed it up at all?

Some numbers:

mysql> select count(*) from kronolith_events;
+----------+
| count(*) |
+----------+
|    68344 |
+----------+
1 row in set (0.00 sec)

mysql> select count(distinct calendar_id) from kronolith_events;
+-----------------------------+
| count(distinct calendar_id) |
+-----------------------------+
|                         349 |
+-----------------------------+
1 row in set (0.69 sec)

# time php reminders.php
X-Powered-By: PHP/4.3.9
Content-Type: text/html; charset=ISO-8859-1

real    9m47.902s
user    0m30.865s
sys     0m0.383s

Thanks!

Chris St. Pierre
Unix Systems Administrator
Nebraska Wesleyan University