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