Database Options


Database Settings and Performance

For best performance MLK optimizes its settings based on the size of your database.  Once it becomes large (more than 20,000 members) MLK will stop caching the entire database into memory and instead only cache as many records are relevant to the current display or search.  Scrolling speed will be slightly reduced, however it will greatly improve start up and mode changing speed.

If you are sharing your database with other users on the network then it is important that you change the setting to "Network Shared Mailing List".  This will ensure that MailList King will strictly save database changes immediately to disk.  This lowers performance, but minimizes the risk of data corruption (Business and Corporate Editions only).

This setting determines whether MailList King will automatically commence a search when changing modes in the main window or selecting a group in "Groups" mode:
- When Checked: Every time you check or uncheck a group MailList King instantly searches and displays the selection
- When Unchecked: A "Display Groups" button is displayed and MailList King will not start searching for groups until the button is clicked

MailList King allows you to create multiple mailing list groups. Typically this is used to separate the mailing lists you manage for different companies or organizations. Specify whether each database will have its own settings, e.g. different reply addresses and sending methods

To reduce the size of your database and improve performance you should regularly optimize it.  MLK can do this automatically every few days or you can initiate it manually by clicking "Optimize Now"

 

Database Records

If you are only using MailList King to manage an e-mail address database then uncheck this option. If you want to also manage physical addresses (where an e-mail address may not be available) then check it

Whether to block duplicate email addresses from being added to the mailing list, i.e. you will get an error if you attempt to add a new member with the same email address as an existing member.  This is the recommended usage of MailList King.

If you enable this option then an address can be listed multiple times in your database if the member's name is different.

Note: Duplicate email address limitations:

Also specify whether to only send once to duplicate addresses.  If you disable this option then MLK will not generate a unique recipient list when sending, i.e. if you have three members with the same email address in the mailing list then three copies of your emails will be sent to their address.

Whether to automatically fix e-mail addresses that have common formatting errors, such as sales@xequte..com or sales2xequte.com

When a member is being added to a mailing list and the country is not specified (Countries can only be specified when using web forms) then the country will be determined by the e-mail address. This option also controls whether the automatic assignment of the Language field (based on the member's country)

 

Back Up Options

How MailList King should back up your data when using File > Back Up or the automatic back up options (below). You can choose to save your back up to a file and/or send it to an e-mail address (for off-site back up).  Note that when saving the month and year will be applied to the save filename (e.g. BackUp-2008-10.csv)

Specify whether MailList King should automatically back up your database.  You can select either:
- Back up when closing MailList King or opening a new database
- Back up at least once a day (will occur on closure if back up has not been performed that day)

 

Advanced Options

Modify other other database and member settings.

 

See Also