Forum OpenACS Development: Re: Notifications package

Collapse
12: Re: Notifications package (response to 1)
Posted by Mark Aufflick on 06/30/03 06:14 AM
simple thought i'm sure has been thought of before:

Would it help to simply reduce the scheduled proc to only run every 5  minutes - or is it the actual bulk of notifications rather than just the  querying that is expensive?

If it would help, i think we can all wait a few minutes to be emailed new posts.

Collapse
13: Re: Notifications package (response to 12)
Posted by Robert Locke on 06/30/03 06:28 AM
Yes, I think that might help.  It would be best if someone could optimize the query though.  And, I wouldn't be surprised if the actual sending out of notifications to everyone was a bit of a hog (acs_mail_lite::sweeper is run every 60 seconds), though I have that disabled on my test system since I don't want to send mail to everyone.
Collapse
14: Re: Notifications package (response to 13)
Posted by Malte Sussdorff on 06/30/03 09:31 AM
Luis Mosteiro wrote a patch for acs-mail-lite (both mat's and the cvs version) that immediatly sends out mails and only stores them in the database if the mailer returned an error. This should reduce the number of read/writes to the database while mailing.