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

[Jonathan Druart]

Hi Philippe,

For the last 2 versions, we have been working a lot on performances,
so it's hard to tell you what we did to fix that.
But have a look at bug 14778, you can try to apply it on 3.20.x and
see if it fixes your issue.
You should plan to move to 16.05 using plack :)

Cheers,
Jonathan

2016-08-01 21:30 GMT+01:00 Philippe Blouin <philippe.blouin at inlibro.com>:
> 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/