Developers of Sympa

[address@concealed]

Salut,

Please disregard my previous email -- there was no need to create and 
maintain a seperate `list_table` database table.

I have made optimizations to get_list() and get_which() that result in a far 
smaller $all_lists array.  Reducing the size of the list-of-Lists returned by 
get_list saves a considerable amount of memory.  


Compare the memory usage before change:
  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1435 sympa     25   0 1017m 971m 3544 R  100 24.5   0:19.13  wwsympa.fcgi 

And after:
  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1620 sympa     18   0  108m  58m 4332 S    0  1.5   0:00.91  wwsympa.fcgi



Three calls to List::get_which occur when a user logs into sympa through 
wwsympa.fcgi. 

There are other calls to List::get_lists inside of wwsympa that I will need 
to optimize this week.

Thanks in advance for any suggestions for further optimizations to help Sympa 
scale effectively.

Word,
Charles