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

[Tomas Cohen Arazi]

It is 3 lines :-D

And <instance> is your instance name, provided you have a packages-based
setup, with created instances.


El mar., 2 ago. 2016 a las 10:06, Philippe Blouin (<
philippe.blouin at inlibro.com>) escribió:

> 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
> 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 at lists.koha-community.org
> <koha-devel-bounces at lists.koha-community.org>
> <koha-devel-bounces at lists.koha-community.org> namens Philippe Blouin
> <philippe.blouin at inlibro.com> <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
> inLibro | pour esprit libre | www.inLibro.com
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/

-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io <http://theke.io/>)
✆ +54 9351 3513384
GPG: B2F3C15F
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160802/42b2b977/attachment.html>