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

  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

    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

E-mail activities

E-mail templates


Related tasks

Configure e-mail activity accounts


+

Search Tips   |   Advanced Search