The mailing list for listmasters using Sympa

[Cretu Adrian <address@concealed>]

  Hi guys

  I had to upgrade an old 5.2.1 sympa to the last debian stable one that is 6.1.11.

  The steps were:

  - dump the old postgress database, create a new mysql database and import the data

  - update the configuration files of the new sympa

  - move the archives to the new server

  - run the upgrade command

 After all this I could login on web on the new sympa and do all sorts of things but everything was slow, even sympa --help or sympa -v is slow.  After enabling mysql logs and a strace on the pid it seems that each time I use the sympa cli or api it does a massive number of mysql selects.

ex:
1496 Query      SELECT value_conf AS value FROM conf_table WHERE (robot_conf ='lists.mydoamin.com' AND label_conf ='color_2')                
1496 Query      SELECT value_conf AS value FROM conf_table WHERE (robot_conf ='lists.mydomain.com' AND label_conf ='color_2')                
1496 Query      SELECT value_conf AS value FROM conf_table WHERE (robot_conf ='lists.mydomain.com' AND label_conf ='color_15') 

root@sympa2:~# time sympa -v
Sympa version is 6.1.11

real    0m26.970s
user    0m7.980s
sys    0m1.980s
root@sympa2:~#

Any hints are welcome , thanks.