[Koha-devel] How long is a call to schema() supposed to take

[Philippe Blouin]

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 at inLibro.com <mailto:philippe.blouin at 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 at lists.koha-community.org 
> <koha-devel-bounces at lists.koha-community.org> namens Philippe Blouin 
> <philippe.blouin at inlibro.com>
> *Verzonden:* maandag 1 augustus 2016 22:30:14
> *Aan:* koha-devel at 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 at inLibro.com <mailto:philippe.blouin at inLibro.com>
>
> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160802/4502b40c/attachment.html>