Yea assuming a 100 every 5 minutes, that's a lot per day.. you could still process them all with a single SQL call but queue up the email notifications.. thing is your notifications will likely be an issue too esp if youre using ActionMailer (which isnt really designed for bulk mail). Youre likely going to have to use net/smtp directly and since the recipients are all different, they have to be processed one at a time.. good news is problem is solvable.
On Sun, Dec 7, 2008 at 10:43 PM, liquid_rails <[EMAIL PROTECTED]>wrote: > > Let's say more than 100 I'm thinking to schedule the process to run > once a day... > > On Dec 7, 6:34 pm, "John Bresnik" <[EMAIL PROTECTED]> wrote: > > If you ran it every 5 minutes - how many records are we talking abt? > > > > On Dec 7, 2008 3:44 PM, "liquid_rails" <[EMAIL PROTECTED]> > wrote: > > > > Everytime I delete a record (i.e. move it to the deleted items > > database) I want to send an email to the poster letting him know that > > his post was deleted. Do you still recommend straight SQL for this? > > > > Thanks! > > > > On Dec 6, 3:43 pm, "John Bresnik" <[EMAIL PROTECTED]> wrote: > Yea you > > really gotta pay attention ... > > > > > On Sat, Dec 6, 2008 at 12:57 PM, caike <[EMAIL PROTECTED]> > wrote: > > > > Actually it really wou... > > > > On Sat, Dec 6, 2008 at 5:22 AM, Steven Fines <[EMAIL PROTECTED]> > > > > wrote: > > >> An even better ... > > > > > >> On Fri, Dec 5, 2008 at 7:33 PM, John Bresnik <[EMAIL PROTECTED]> > > > > wrote: > > >>> You should str... > > > > > >>> On Dec 5, 2008 1:38 PM, "liquid_rails" <[EMAIL PROTECTED]> > > > >>> wrote: > > >>> Thanks, but I don't even know how to write the > script > > > > or the code for > >>> mov... > > > --~--~---------~--~----~------------~-------~--~----~ SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby -~----------~----~----~----~------~----~------~--~---
