bulk email solutions

Philip_Hallstrom · August 20, 2009, 9:06pm

Hard to say without knowing how many customers that query is going to return... if it's under a 100 it doesn't matter. Under a 1000 it probably doesn't matter. If it's 10,000 and it's once a week, neither is going to be very fun. Keep in mind that those queries will instantiate however many objects that match... you could suck up a lot of memory... at least use the new find/block stuff.

Might want to look into ar_mailer (ruby stuff), bulk_mailer (stand alone) and if your volume is high one of the companies that does this for a living so you don't have to deal with ending up on aol/msn/yahoo's spam blacklists...

-philip

11175 · August 20, 2009, 9:21pm

Hard to say without knowing how many customers that query is going to return... if it's under a 100 it doesn't matter. Under a 1000 it probably doesn't matter.

i have under 500 customers

of memory... at least use the new find/block stuff.

what is it?

thanks

Philip_Hallstrom · August 20, 2009, 9:34pm

Hard to say without knowing how many customers that query is going to return... if it's under a 100 it doesn't matter. Under a 1000 it probably doesn't matter.

i have under 500 customers

If it were me I'd email them each individually and customize the email to include their full name in the to field, a "hello Aldo" in the message, and a one-click unsubscribe url. Doesn't matter how you send them with only 500.

of memory... at least use the new find/block stuff.

what is it?

I can never remember the exact syntax... it's a new method that lets you issue a find and then iterate through it say 100 objects at a time -- so that you aren't building an array of 10,000 objects. Google around and you'll find it.

-philip

James_Englert · August 20, 2009, 9:46pm

I’ve googled a bit and I can’t seem to find it. Could you do me a huge favor and link me?!

Philip_Hallstrom · August 20, 2009, 9:55pm

I've googled a bit and I can't seem to find it. Could you do me a
huge favor and link me?!

find_each is what it's called...

github.com

rails/rails/blob/106976df0911e423042ec4abc165fd561766a047/activerecord/lib/active_record/batches.rb#L47


      
          # It's not possible to set the order. That is automatically set to ascending on the primary key ("id ASC") 
          # to make the batch ordering work. This also mean that this method only works with integer-based primary keys.
          # You can't set the limit either, that's used to control the the batch sizes.
          #
          # Example:
          #
          #   Person.find_in_batches(:conditions => "age > 21") do |group|
          #     sleep(50) # Make sure it doesn't get too crowded in there!
          #     group.each { |person| person.party_all_night! }
          #   end
          def find_in_batches(options = {})
            raise "You can't specify an order, it's forced to be #{batch_order}" if options[:order]
            raise "You can't specify a limit, it's forced to be the batch_size"  if options[:limit]
          
            start = options.delete(:start).to_i
            batch_size = options.delete(:batch_size) || 1000
          
            with_scope(:find => options.merge(:order => batch_order, :limit => batch_size)) do
              records = find(:all, :conditions => [ "#{table_name}.#{primary_key} >= ?", start ])
          
              while records.any?

-philip

Topic		Replies	Views
re: [Rails] 500 error in sending bulk mail rubyonrails-talk	0	115	January 15, 2010
Bulk Emailers rubyonrails-talk	2	95	July 17, 2008
Rails web hosting - spam email policy rubyonrails-talk	3	160	July 28, 2007
high volume email sending rubyonrails-talk	4	87	June 6, 2008
Using multiple SMTP servers with Rails - avoiding blacklisting rubyonrails-talk	2	235	July 25, 2009

bulk email solutions

Related topics

More Resources