[Koha-bugs] [Bug 16079] Retrieving system preferences from database via DBIx is not fast enough

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16079

--- Comment #17 from Jacek Ablewicz <abl at biblos.pk.edu.pl> ---
(In reply to Marcel de Rooy from comment #16)

> DBIx::Class 0.08196 vs 0.082810

> WHEEZY WITHOUT 16079
> Mysql
> real    0m1.966s

> Hash ref inflator
> real    0m16.663s

> Unblessed
> real    0m20.411s

> === JESSIE WITHOUT 16079
> Mysql
> real    0m2.092s

> Hashref inflator
> real    0m2.991s

> Unblessed
> real    0m6.603s

Thanks Marcel, good to know that speed improvements (both DBIx::Class 0.08196
vs 0.082810, and unblessed vs hashref inflator) are real, not just some weird
local artefacts.

I see that wheezy support got just depreciated, as of 16.11, in the last IRC
dev meeting (unanimously :), so the possibly insufficient performance of the
older DBIx::Class is most likely not to be a problem in the long term.

Hashref inflator seems to be a lot better then unblessed (over 2x faster,
almost as fast as pure DBI) especially in jessie; using it instead of unblessed
may be well worth it in speed-sensitive places.

Any ideas how to implement hashref inflator method / variant inside
Koha::Object[s] without violating (too much ;) the underlying principles of
Koha::Objects?

-- 
You are receiving this mail because:
You are watching all bug changes.