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