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