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,