The mailing list for listmasters using Sympa

["Adam Bernstein" <address@concealed>]

Oops, uh... nevermind.  I just saw that the index creation is in 
the create_db file (in 3.4.4.3) and is live on one of our servers,
so I don't know why it was missing from the other server.  It's a
mystery for us to solve, but probably not interesting or relevant
for anyone else.

Sorry for the misguided excitement.

    ab

> -----Original Message-----
> From: Adam Bernstein [mailto:address@concealed]
> Sent: Saturday, January 24, 2004 1:09 PM
> To: address@concealed
> Subject: [sympa-users] BIG performance boost for big lists!
> 
> 
> I have just discovered a HUGE performance booster for Sympa with
> big lists (50,000+ subscribers) in MySQL:  Add a single-column index
> to the email_user column in user_table, and a two-column index to the
> email_subscriber and list_subscriber columns in subscriber_table.
> Subscriber list generation and display is now MANY times faster, as
> is import and export of large (1000+) subscriber lists.  (We have
> added an Export List function to the Web interface.)
> 
> I did this through phpMyAdmin, but you can use the CREATE INDEX
> command of MySQL.
> 
> And Olivier or Serge: I think this would be a great modification to 
> the default table structure of Sympa, as it won't hurt with small 
> lists either.
> 
>     ab
> -- 
> ----------------------------------------------------------------------
> *           Electric Embers:  Powering the fires of change           *
> * Web, Email, List, and Antivirus/Antispam hosting for the community *
> *  http://electricembers.net   Member of http://techunderground.org  *
> ----------------------------------------------------------------------
>