Developers of Sympa

[Olivier Salaun <address@concealed>]

Hi,

Fil wrote:

> after checking why my wwsympa was so sloooooooooww  (like minutes before
> giving me a do_search(address@concealed) I went into the code and discovered the
> sad truth ;)
> 
> * wwsympa
>     1) asks the SQL database to give it a full list of subscriber
>     2) on each subscriber, checks to see if it matches the regexp
>     3) prints these records that match
> 
> So what's the database useful for? (In French: "A quoi ça sert que mysql se
> décarcasse?")
> 
>  wwsympa should
>     1) ask the SQL database for THOSE RECORDS THAT MATCH regexp
>     2) process that short list

You're right : List::get_first_user() should take another 'filter'
argument.

> The same is true when wwsympa wants to print out only the subscribers 100 to
> 125 : it should not request all then select a short list, but it should
> issue a LIMIT 100,125 command in its SQL request.

NO, LIMIT is used when doing a REVIEW.
Did you check your MySQL log ?

--
Olivier Salaün
Comité Réseaux des Universités