[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 #16 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
DBIx::Class 0.08196 vs 0.082810
WHEEZY WITHOUT 16079
Mysql
master-koha at WRKM006:/usr/share/koha/masterclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 552 sysprefs
real    0m1.966s
user    0m1.844s
sys     0m0.072s
Hash ref inflator
master-koha at WRKM006:/usr/share/koha/masterclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 552 sysprefs
real    0m16.663s
user    0m16.433s
sys     0m0.136s
Unblessed
master-koha at WRKM006:/usr/share/koha/masterclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 552 sysprefs
real    0m20.411s
user    0m20.229s
sys     0m0.092s

=== WHEEZY WITH 16079
Mysql
master-koha at WRKM006:/usr/share/koha/masterclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 552 sysprefs
real    0m1.986s
user    0m1.856s
sys     0m0.080s
Hashref inflator
master-koha at WRKM006:/usr/share/koha/masterclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 552 sysprefs
real    0m14.909s
user    0m14.725s
sys     0m0.104s
Unblessed
master-koha at WRKM006:/usr/share/koha/masterclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 552 sysprefs
real    0m21.267s
user    0m21.053s
sys     0m0.124s

=== JESSIE WITHOUT 16079
Mysql
upgrade-koha at UPGRADE:/usr/share/koha/upgradeclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 509 sysprefs
real    0m2.092s
user    0m1.976s
sys     0m0.072s
Hashref inflator
upgrade-koha at UPGRADE:/usr/share/koha/upgradeclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 509 sysprefs
real    0m2.991s
user    0m2.884s
sys     0m0.072s
Unblessed
upgrade-koha at UPGRADE:/usr/share/koha/upgradeclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 509 sysprefs
real    0m6.603s
user    0m6.460s
sys     0m0.112s
JESSIE WITH 16079
Mysql
upgrade-koha at UPGRADE:/usr/share/koha/upgradeclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 509 sysprefs
real    0m2.032s
user    0m1.892s
sys     0m0.100s
Inflator
upgrade-koha at UPGRADE:/usr/share/koha/upgradeclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 509 sysprefs
real    0m2.944s
user    0m2.868s
sys     0m0.044s
Unblessed
upgrade-koha at UPGRADE:/usr/share/koha/upgradeclone$ time
misc/tests/_dbix_test_search_performance_all_sysprefs.pl
Got 509 sysprefs
real    0m6.494s
user    0m6.392s
sys     0m0.060s

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