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

[Mirko Tietgen]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20151130/cd3118cc/attachment.pgp>