[Koha-devel] Benchmarks - prior to the 3.22 release

[Jonathan Druart]

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 at 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 at 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/