[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 #15 from Jacek Ablewicz <abl at biblos.pk.edu.pl> ---
Apparently there is a substantial performance difference in regards of DBIx
search speed between DBIx versions 0.08196 (in wheezy) and 0.082810 (in
jessie).

Simple DBIx searches (if we only want array of hashes as a result), with some
additional tweaking (using DBIx::Class::ResultClass::HashRefInflator), are
almost as fast as plain DBI in DBIx::Class v0.082810 (?).

I uploaded some quick & dirty benchmarking code in Bug 16076, there seems to be
quite a huge difference:

    # current master (08/07/2016) on Wheezy
    # (DBIx::Class version 0.08196, i7-3770 CPU @ 3.40GHz)
    #
    #     $results = sysprefs_from_mysql(); ## 1.82 msec
    #     $results = sysprefs_dbix_hashref_inflator(); ## 12.5 msec
    #     $results = sysprefs_dbix_unblessed(); ## 17.6 msec

    # 3.22.x on Jessie (DBIx 0.082810, i7-930 CPU @ 2.80GHz)
    #
    #     $results = sysprefs_from_mysql(); ## 2.52 msec
    #     $results = sysprefs_dbix_hashref_inflator(); ## 3.51 msec
    #     $results = sysprefs_dbix_unblessed(); ## 7.9 msec

Can someone please confirm those results? I tested it on two (not exactly
directly comparable) hardware setups - IMO, DBIx version is likely the most
important difference, but I can't exclude the possibility that there may be
some other factors involved.

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