The mailing list for listmasters using Sympa

[Petr Prazak <address@concealed>]

2.7.2001, Erol Ozcan wrote on subject `[sympa-users] Re: wwsmpa.fcgi is 
eating too much cpu':

>    I think the problem is related with database operations. I have added a
> list called "everybody" which is currently included more than 70.000
> subscribers. Also there are more lists with more than 30.000 subscribers.
> The wwsympa list manager web pages are displayed very slowly after i added
> new lists with many subscribers. Sometimes server does not respond ( might
> be timeout  reason ), i could not get any page.

I have a mailing list with almost 400.000 subscribers and the page
loads quite quickly. I have just some 10 lists. How many lists do you have ?

>    One of the possible solution ( probably the best )  for this problem,
> sympa could cache the lists from database once per session, not every
> requested page. Also database fetching could be optimized. Do you have any
> solution?

Well, the db schema leaves much to be desired. :)

>>     I am using Sympa 3.2.1 on RH 6.2 - 2.2.19enterprise kernel.
>> wwsympa.fcgi process  is eating too much CPU, about %75 , when i visit
>> wws pages. Is it normal?

My machine is PIII/550 MHz with 512 MB RAM. MySQL version 3.23.32.


-- 
Petr Prazak
GRISOFT(c) SOFTWARE