Mass Emailer

[William Park]

Metnetsky <matt at uberstats.com> wrote:
> I have about 3000 emails stored in a database which I would like to retrieve 
> and then send out.  As I'm new to Python I'm not sure of the best way to 
> perform this function without bogging down everything (python, smtp, etec).  
> The following two ways have come to mind, please let me know which you all 
> think would be best.  Naturally a mysterious third option is definitely 
> welcome.
> 
> Option #1:
>        Connect to the database, pull the records, and then disconnect from 
>        the database.  Go through each record and send emails one-by-one to each
>        user in the system.  This sounds like a HUGE bog on the system, but I 
>        could be wrong.
> 
> Option #2
>        Same as above except sending each email with 20 (or more) user addresses.
>        This would cut down the bog I expect by an estimated 20% at least.
> 
> 
> Suggestions, ideas, comments, complains....all are welcome
> 
> ~ Matthew

3000 emails is not a big deal, for a real MTA like Sendmail.  You don't
even have to do this in Python.

-- 
William Park, Open Geometry Consulting, <opengeometry at yahoo.ca>
Linux solution for data management and processing.