Thanks, Howie.
> -----Original Message-----
> From: Howie Hamlin [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 15, 2004 9:18 PM
> To: inFusion Support List
> Subject: Re: [iMS] Outbound mail transactions
>
>
> Just a note that I'm having someone look into this here. I'll
> respond within the week.
>
> Regards,
>
> Howie
>
> ----- Original Message -----
> From: "Raven R. Cecil" <[EMAIL PROTECTED]>
> To: "inFusion Support List" <[EMAIL PROTECTED]>
> Sent: Friday, March 12, 2004 4:45 PM
> Subject: RE: [iMS] Outbound mail transactions
>
>
> > Howie,
> >
> > I understand that failures can generate higher than 100% counts when
> > compared to the total recipients, but these numbers are
> showing much lower
> > counts.
> >
> > Here are the counts on average:
> > (I have currently logged over 10,000 separate mailings, and
> these numbers
> > are consistent throughout.)
> >
> > > 10000 recipients: 90-100% delivery
> > > 30000 recipients: 80-90% delivery
> > > 50000 recipients: 70-80% delivery
> >
> > That is where the numbers tend to break off. Even with
> mailings that have
> > recipients in the hundreds of thousands I rarely find
> counts lower than 70%,
> > and in those cases it is normally an issue with missing
> control files. So,
> > in effect, I have only sent 50% of the mailing, and those
> numbers are
> > discounted as a separate issue.
> >
> > Considering the failure counts I would expect all the
> counts to be at least
> > 100% of the recipient count, but this is not the case.
> >
> > I have also logged each address separately, and using a
> unique constraint on
> > the address and mailing ID fields to prevent more than one
> record per
> > mailing. However, the counts are still way below expectations.
> >
> > I suggested the app server connection setting as a possible
> failure point,
> > if POST dropped some of the queued requests to the CF
> server, then that
> > would explain a lot of the counts. The query I use executes
> in < 20ms (I
> > have timing code monitoring it's execution times). So, I do
> not feel it is
> > an issue with the template itself, especially since POST is
> set to use only
> > a single connection to CF on a dedicated, dual-processor
> machine. Specs:
> >
> > Compaq Proliant ML370
> > Pentium III 733 x 2
> > RAID 1 x 9GB x 2 [10K RPM]
> > RAM 2GB
> >
> > I appreciate any insight into this issue.
> >
> >
> > Warm Regards,
> >
> > Raven Cecil
> >
> >
> ......................................................................
> > "Patience and perseverance have a magical effect before which
> > difficulties disappear and obstacles vanish." - John Quincy Adams
> >
> > "They that give up essential liberty to obtain a little temporary
> > safety deserve neither liberty nor safety." - Benjamin Franklin
> >
> > "find / -user you -name "*base*" -exec chown us {} \;" - Linux Admin
> >
> ......................................................................
> >
> > > -----Original Message-----
> > > From: Howie Hamlin [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, March 11, 2004 4:07 PM
> > > To: inFusion Support List
> > > Subject: Re: [iMS] Outbound mail transactions
> > >
> > >
> > > The numbers should be accurate. You just have to realize
> > > that a single email can have 0 or more temp failures. Why do
> > > you think the numbers don't add up?
> > >
> > > If the app server connections are set to 1 then the POST
> > > Server will internally queue requests to the app server so
> > > you should be OK.
> > >
> > > HTH,
> > >
> > > Howie
> > >
> > > ----- Original Message -----
> > > From: "Raven R. Cecil" <[EMAIL PROTECTED]>
> > > To: "inFusion Support List" <[EMAIL PROTECTED]>
> > > Sent: Thursday, March 11, 2004 4:02 PM
> > > Subject: [iMS] Outbound mail transactions
> > >
> > >
> > > > Hi everyone,
> > > >
> > > > I need to log and count all outbound POST transactions
> (successful,
> > > > permanent, temporary) into our SQL database, in real-time.
> > > >
> > > > I have tried simply logging counts from Report Post Status
> > > using a query,
> > > > and the numbers do not add up. Here is my query:
> > > >
> > > > <cfquery datasource="#request.maindsn#" name="UpdateMailCounts">
> > > > set transaction isolation level read committed
> > > > begin transaction
> > > > update [mailcounts]
> > > > set
> > > > [mailcounts].[DeliveryCount] =
> > > > [DeliveryCount] + #ListLen(form.deliveredlist)#,
> > > > [mailcounts].[PermanentCount] =
> > > > [PermanentCount] + #ListLen(form.permfailedlist)#,
> > > > [mailcounts].[TemporaryCount] =
> > > > [TemporaryCount] + #ListLen(form.tempfailedlist)#
> > > > where MailCountID = #attributes.MailCountID#
> > > > commit transaction
> > > > </cfquery>
> > > >
> > > > Has anyone accomplished this with 100% accuracy? Is it
> > > possible to log every
> > > > mail transaction into a table?
> > > >
> > > > Also, how low should POST threads be set if RPS is called
> > > for every control
> > > > file, and Simultaneous App Connections is set to 1? Can
> > > POST use 255 threads
> > > > if every thread requires a call to the RPS template?
> > > >
> > > > TIA
> > > >
> > > >
> > > > Warm Regards,
> > > >
> > > > Raven Cecil
> > > >
> > > >
> > >
> ......................................................................
> > > > "Patience and perseverance have a magical effect before which
> > > > difficulties disappear and obstacles vanish." - John
> Quincy Adams
> > > >
> > > > "They that give up essential liberty to obtain a little
> temporary
> > > > safety deserve neither liberty nor safety." - Benjamin Franklin
> > > >
> > > > "find / -user you -name "*base*" -exec chown us {} \;"
> - Linux Admin
> > > >
> > >
> ......................................................................
==^=======================================================
This list server is Powered by iMS "The Swiss Army Knife of Mail Servers"
--------------------------------------------------------------------------------------
This list is provided as a free service. Although we will try to address issues
in a timely manner, support via this list is not guaranteed. If you require expedited
support then a support contract is required. Support may be purchased from
http://www.coolfusion.com/commerce. Details regarding support options may be reviewed
at: http://www.coolfusion.com/SupportOptions.cfm
--------------------------------------------------------------------------------------
To leave this list please complete the form at http://www.coolfusion.com/Support/
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/Developers/
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [EMAIL PROTECTED]
==^=======================================================
