Improving Email activity sending performance

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

About this task

In the PROPERTYFILE column of the EMLMSG database table, you 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 you want to use 20 threads
    UPDATE EMLMSG SET PROPERTYFILE = 
    'CONTENT=GENERIC;THREADCOUNT=20;' 
    WHERE EMLMSG_ID = 25;