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