Ok, so write an net/smtp script to send out email notifications and a seperate sql script to move the records to another database, and execute both scripts via cronjob?
On Dec 8, 1:27 pm, "John Bresnik" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
