User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
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

Note: You must be registered in order to post a reply.

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
xequte Posted - Jul 28 2010 : 14:57:57
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