Skip to Content.
Sympa Menu

en - Re: [sympa-users] sql data source updating membership

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Youcef N Baouchi <address@concealed>
  • To: Steve Shipway <address@concealed>, "address@concealed" <address@concealed>
  • Subject: Re: [sympa-users] sql data source updating membership
  • Date: Tue, 29 Jan 2019 04:11:41 +0000

thank you. I'll give this a try.


From: Steve Shipway <address@concealed>
Sent: Monday, January 28, 2019 7:05:38 PM
To: address@concealed
Cc: Youcef N Baouchi
Subject: Re: [sympa-users] sql data source updating membership
 
If you set the data source parameter distribution_ttl to be something relatively small -- for example, 3600 (1 hour) -- then the data source (in this case, the SQL) will be queried if there is a message to distribute AND the cached data are older than this.

Then, set the ttl to be something very big -- for example, 2592000 (1 month).  The SQL will be automatically queried if the cached data are older than this.

So, it's still querying on a timer, but it is a *very long* timer.  If you expect to get at least one mail to the list per month, then you'll never see the time query trigger as the data will never get this old.  I've seen lists with an expensive-to-query external data source use this method (low distribution_ttl but high ttl) in the past to avoid unnecessary lookups.

Steve

On Mon, 2019-01-28 at 23:11 +0000, Youcef N Baouchi wrote:

Hi All,

 

We have host that has thousands of lists that use a sql data source for to add / remove members from the lists. Is there a way to configure Sympa to query the data source only when / before the list is emailed? I don’t want it to query the source on a timer.

 

Thanks

 

Youcef

 

--
Steve Shipway | Senior Email Systems Administrator 
Phone: +64 9 302 0515 Fax: +64 9 302 0518 
Freephone: 0800 SMX SMX (769 769) 
SMX Limited: Level 10, 19 Victoria Street West, Auckland, New Zealand 
Web: http://smxemail.com 

This email has been filtered by SMX. For more information visit smxemail.com.



Archive powered by MHonArc 2.6.19+.

Top of Page