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

inLibro | pour esprit libre | 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

inLibro | pour esprit libre | www.inLibro.com