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;

Related concepts
Email activities
Email templates

Related tasks
Configure email activity accounts
Configure the store to avoid sending multiple marketing e-mails to the same email address
Forcing email activities to be sent right away during testing
Viewing emails that were not delivered

Related reference
Troubleshooting: Marketing activity is not sending email messages as expected