Eelco van Beek wrote: > Hi Paul, > > What about adding this to the dbmail-util program to check of > out-of-date auto replies? It will save performance.
Ahem, anyone will be free to submit this as a bug once they start noticing performance degradation while running dbmail-util. > > Best regards, > > Eelco > > On Mon, 8 Aug 2005, Paul J Stevens wrote: > >> Some of todays action in svn-trunk: >> >> I've added two new datetime fields to the dbmail_auto_replies table >> called start_date and stop_date. This way activation and deactivation of >> auto_replies is shoot and forget. If no start_date and/or stop_date is >> specified in the table, default values are used in the query. >> >> "SELECT reply_body FROM %sauto_replies " >> "WHERE user_idnr = %llu " >> "AND NOW() BETWEEN COALESCE(start_date,DATE '1900-01-01') " >> "AND COALESCE(stop_date, DATE '3000-01-01'", DBPFX,user_idnr); >> >> this way, rather than using default values in the table, if a user >> clears such a value, auto_reply behaviour should still follow the rule >> of least surprise. >> >> >> >> >> -- >> ________________________________________________________________ >> Paul Stevens paul at nfg.nl >> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 >> The Netherlands________________________________http://www.nfg.nl >> _______________________________________________ >> Dbmail-dev mailing list >> Dbmail-dev@dbmail.org >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev >> > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
