User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
Password:
Save Password
Forgot your Password?

     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 Performance of Shared Databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

xequte

7504 Posts

Posted - Jul 28 2010 :  14:57:57  Show Profile  Reply
Hi

If you are sharing an MLK mailing list amongst multiple MailList King installations then there are some settings you need to set.

Database Sharing and Performance (View > Options, Other)

1. Allow sharing of database

If you may have two users editing the mailing list at the same time enable this option to prevent collisions.


2. Limit database cache to 500 records

This option needs to be enabled for any database larger than 20,000 members, or 10,000 members if the database is being shared. While it reduces some functionality it greatly increase load and refresh speed


3. Disable automatic searching

Generally recommended when sharing large databases over the network


4. Use a different configuration for each database

When you are sharing a database, you probably also want to share your settings (i.e. so every MLK installation uses the same settings). So enable this option on each MLK installation so that the settings are stored with the database rather than on the local machine.


5. Optimistic Record Locking (Advanced)

If you have a lot of users editing your mailing list simultaneously then an advanced option is available to prevent problems accessing a member record that is currently open for editing.

See the OptimisticRecordLocking setting in Hidden Options


Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: