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]
==^=======================================================
