Re: [GENERAL] large crontab database design

2004-02-03 Thread Csaba Nagy
David, I have another solution working (not using data base persistence, but the idea is the same). We have the next run time saved along with the original cron-tab string, which is left as it is (not broken down to any details). The system polls for the earliest "next runtime", and executes the a

[GENERAL] large crontab database design

2004-02-03 Thread David Garamond
I was thinking on how one would design an optimal (performance-wise) database of large number of schedules with crontab-like semantic. There will potentially be hundreds of thousands or even millions of "crontab" entries, and there will be a query run once every minute to determine which entrie