The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

On 16/08/16 08:21, Youcef N Baouchi (via sympa-users Mailing List) wrote:

Does anyone know in which file the lookup occurs for Index of Lists? The index of lists is very slow for us. It can take up to 40 seconds to display a list of 1700 lists. I’m assuming it’s a db call, but I can’t find it anywhere.

 

I'm a bit out of the loop on this, as I don't work with sympa these days, but in the past I had to improve performance with tens of thousands of lists; by examining mysql logs, I found performance massively increased by the following :
- I added a couple more indices to the lists table.  I can't remember which.  I just logged slow queries and then 'explained' them to find out what indices would help speed them up
- Tuned mysql to ensure the indices could be kept in memory and were cached which had a huge win
- Tweaked the sympa code with the riseup patch and similar to take advantage of the MySQL  RLIKE function for searches so that there are no sequential filters on the list of lists.  These may be in 6.2 now but I think that mysql-specific things may not have made the cut

Steve

--

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 15, 19 Victoria Street West, Auckland, New Zealand
Web: http://smxemail.com

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