Administer > Manage WebSphere Commerce features > Marketing
Improve e-mail activity sending performance
You can set two parameters in the EMLMSG database table that can improve performance when sending marketing e-mails using e-mail or Dialog activities.
In the PROPERTYFILE column of the EMLMSG database table, you can set the following optional parameters for a given e-mail message template:
- CONTENT=GENERIC
- Set this parameter if the e-mail content is the same for all customers, that is, the e-mail template does not generate content that is personalized for individual customers. As a result, the marketing services create the e-mail JSP only one time, and the same e-mail content is sent to all customers.
- THREADCOUNT=value
- Set this parameter to increase the number of threads handling the e-mail sending. This can shorten the time it takes to send a large number of e-mails. The number for value represents the number of threads. The THREADCOUNT value must be number ending with 0, that is, 10, 20, 30, and so on.
Procedure
- Access the development database.
- Run the following SQL statement:
UPDATE EMLMSG SET PROPERTYFILE = 'email_performance_parameters;' WHERE EMLMSG_ID = emlmsg_id;
Where:
- email_performance_parameters
- is any of CONTENT=GENERIC and THREADCOUNT=value.
Each parameter must end with a semi-colon (;).
- emlmsg_id
- is the numeric ID assigned to the e-mail message
Here is an example SQL command that could improve performance for an e-mail activity that:
- Sends generic content to all customers
- Has a large distribution list, so to use 20 threads
UPDATE EMLMSG SET PROPERTYFILE = 'CONTENT=GENERIC;THREADCOUNT=20;' WHERE EMLMSG_ID = 25;
Related concepts
Related tasks
Configure e-mail activity accounts