After some quick tests: on 3.22, using the selenium tests (see bug 13691 and the wiki page "Benchmark for 3.22"): I have tried without plack only: 3.22 + memcached, 3.22 - memcached with and without 11842 And I have not noticed a difference (same execution time for the whole bench of tests). 2015-11-30 10:07 GMT+00:00 Mirko Tietgen <mirko@abunchofthings.net>:
Tomas Cohen Arazi schrieb am 27.11.2015
Could you try reverting to old DBI syspref retrieval in C4::Context?
I did a lot of speed tests over the weekend, and I think that is not the main problem.
I do not see a huge drop in speed in all areas, but search speed with Plack in 3.18 is 1/3 of that in 3.16.
I found two areas so far that seem problematic.
1. The anti-cache stuff introduced in bug 11842 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11842
The cache is deleted all the time, eg. the framework structure is fetched again and again for every single result in a search (related to 2. below)
When I revert that patch, I speed up search from 30 to 23 seconds for a repeated search in OPAC with multiple results (once the frameworks are cached). Not enough, but a good start.
2. The handling of XSLT when building the results page, related to C4::XSLT.
When I tested Koha 3.8 on the Raspberry Pi in 2012, a search with one result took 2x the time of one with multiple results, because after finding the single result, you get redirected to the detail page automatically.
Nowadays, the search with a single result is much faster than that of one with multiple results, because we lose a lot of time building the results page.
Also, a search with multiple results is twice as fast when XSLT view is disabled in the sysprefs. I have not tried how it was in 3.16 yet.
For every single result in a search, a lot of things are repeated all over again. A huge bunch of sysprefs is fetched every time, even though it is not likely they will change while fetching all results of one search query. GetMarcStructure seems to be a problem (see 1. above) but others may be too. Bug 11051 seems related. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11051
There is probably more and I will do more testing.
Jonathan: could you check if the first point may be relevant for your selenium tests?
Cheers,
Mirko
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/