Improving Email activity sending performance

We can set two parameters in the EMLMSG database table that can improve performance when using Email or Dialog activities to send marketing emails.

Task info

In the PROPERTYFILE column of the EMLMSG database table, we can set the following optional parameters for an email message template:

CONTENT=GENERIC

Set this parameter if the email content is the same for all customers. For examples, if your email template does not generate content that is personalized for individual customers. As a result, the marketing services create the email JSP only one time, and the same email content is sent to all customers.

Procedure

1. Access the development database.

2. Run the following SQL statement:

   UPDATE EMLMSG SET PROPERTYFILE = 
   'email_performance_parameters;' 
   WHERE EMLMSG_ID = emlmsg_id; 

   where:

   email_performance_parameters

   The value of any of CONTENT=GENERIC and THREADCOUNT=value. Each parameter must end with a semi-colon (;).

   emlmsg_id

   The numeric ID assigned to the email message.

   Here is an example SQL command that could improve performance for an email activity that

   • Sends generic content to all customers

   • Has a large distribution list, so we want to use 20 threads

   UPDATE EMLMSG SET PROPERTYFILE = 
   'CONTENT=GENERIC;THREADCOUNT=20;' 
   WHERE EMLMSG_ID = 25;