This is Jessie. That's maybe part of the issue, though. While changing hardware, we also upgraded the OS/apache/mysql. I was kinda hoping for some big gain, but this 1sec delay really stands out. But following everyone's comments, ll look into 14478, plack... and simply moving everything to 16.05 :) Any good doc on plack? I got https://wiki.koha-community.org/wiki/Plack, but 5 lines aren't much, not even a clue what <instance> is :) Thanks everyone! Philippe Blouin, Responsable du développement informatique Tél. : (888) 604-2627 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 08/02/2016 05:30 AM, Marcel de Rooy wrote:
Philippe,
Are you using Jessie or Wheezy ?
I have seen some interesting performance differences between the versions of DBIx shipped with these Debian versions.
Jessie is much faster.
Marcel
------------------------------------------------------------------------ *Van:* koha-devel-bounces@lists.koha-community.org <koha-devel-bounces@lists.koha-community.org> namens Philippe Blouin <philippe.blouin@inlibro.com> *Verzonden:* maandag 1 augustus 2016 22:30:14 *Aan:* koha-devel@lists.koha-community.org *Onderwerp:* [Koha-devel] How long is a call to schema() supposed to take Hello Koha developpers!
I got a question to all the dbix experts out there (I'm not one of them, unfortunatly). I have performance issues in the checkout that remains even after boosting my server's performance with a SSD drive.
In C4/Circulation.pm/*AddIssue*, a lot of transactions take >1s for the call to schema $issue =
Koha::Database->new()->_*schema()*_->resultset('Issue')->create(
This is *3.20*. I specifically isolated that call with timers, I do a bunch of checkouts for the same user, and repetitively, that call take over 1s. The machine is a beast (ram, cpu...), so what should I be doing?
Thanks, -- Philippe Blouin, Responsable du développement informatique
Tél. : (888) 604-2627 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>