Foswiki FastCGI Multithreading Support?

Hi guys,

we are currently upgrading from foswiki 1.1.9 to the newest 2.0.3 using a new server and a new installation.

In the course of this upgrade, our goal is to increase the performance of our foswiki installation (in the old installation, some big topics take up to 10 seconds to load, which is not acceptable for our users)

To do this, we set up the new installation with FastCGI and use Database caching of the wiki pages.

The new VM is a 3 CPU, 2GB RAM machine and we startet the fastcgi script as daemon "/usr/bin/perl ./foswiki.fcgi --listen :8080 --nproc 3 --pidfile /var/run/foswiki.pid --daemon" and let the apache webserver connect to it.

We also configured RcSWrap as StoreImplementation and Forking as SearchAlgorithm.

However what occured is, that if you open a big wiki page, the daemon is using 100% of one cpu core and the other idle around.

The wiki pages are indeed loading faster, but there is still 6-7 seconds wait time.

Is there a possibility to make this process use multiple cores? Or i am stiill missing sth in my configuration and the perl code should not be compiled when accessing a wiki page?

I really appreciate any input!

Thanks

Horst

-- HorstBirne - 15 Jan 2016

No, unfortunately, any one transaction only gets a single thread. The way to deal with slow topics is to dig into what's making them slow. Large searches are usually the culprit. There are things that can be done to tune the SEARCH, and extensions like the MultiSearchPlugin that can help for really complex needs. Sometimes it can be as simple as adding a topic="SomePrefix*" option to a search to reduce the number of topics scanned. If it's extremely large tables, try disabling the EditRowPlugin which will simplify the generated html. For large text searches, things like SolrPlugin can help.

-- GeorgeClark - 15 Jan 2016