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 <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Or send that newer versions of dbix class have improved efficiencies. You might want to experiment with using newer versions of the module than what comes with that version of Koha by default. Kyle Sent from my phone. Please excuse my brevity. On Aug 1, 2016 4:30 PM, "Philippe Blouin" <philippe.blouin@inlibro.com> wrote:
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
_______________________________________________ Koha-devel mailing list Koha-devel@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/
Hi Kyle! Not sure I understand your first sentence... But what you tell me is to try to move to 3.20.X, with X great than the 3.20.01 that I currently run? Not easily feasible with the stack over it, but just knowing that it is software and has been worked on is good news to me. Thanks! Philippe Blouin, Responsable du développement informatique Tél. : (888) 604-2627 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 08/01/2016 04:32 PM, Kyle Hall wrote:
Or send that newer versions of dbix class have improved efficiencies. You might want to experiment with using newer versions of the module than what comes with that version of Koha by default.
Kyle
Sent from my phone. Please excuse my brevity.
On Aug 1, 2016 4:30 PM, "Philippe Blouin" <philippe.blouin@inlibro.com <mailto:philippe.blouin@inlibro.com>> wrote:
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 <tel:%28888%29%20604-2627> philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <mailto:Koha-devel@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/
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@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@inLibro.com
inLibro | pour esprit libre | www.inLibro.com
_______________________________________________ Koha-devel mailing list Koha-devel@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/
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<mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com<http://www.inLibro.com>
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 <mailto:philippe.blouin@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@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 <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
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@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@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> <koha-devel-bounces@lists.koha-community.org> namens Philippe Blouin <philippe.blouin@inlibro.com> <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
_______________________________________________ Koha-devel mailing list Koha-devel@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
haaaa, No, got git setups. Any instructions on that? two lines maybe? one? :-) Was wondering actually if having plack for one install on 16.05 would break another installation on 3.20 sharing apache. Most things Apache are secluded by virtual host, but some are global. I live in fear... Philippe Blouin, Responsable du développement informatique Tél. : (888) 604-2627 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 08/02/2016 09:27 AM, Tomas Cohen Arazi wrote:
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@inlibro.com <mailto:philippe.blouin@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@inLibro.com <mailto:philippe.blouin@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@lists.koha-community.org <mailto:koha-devel-bounces@lists.koha-community.org> <koha-devel-bounces@lists.koha-community.org> <mailto:koha-devel-bounces@lists.koha-community.org> namens Philippe Blouin <philippe.blouin@inlibro.com> <mailto:philippe.blouin@inlibro.com> *Verzonden:* maandag 1 augustus 2016 22:30:14 *Aan:* koha-devel@lists.koha-community.org <mailto: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 <mailto:philippe.blouin@inLibro.com>
inLibro | pour esprit libre | <http://www.inLibro.com>www.inLibro.com <http://www.inLibro.com>
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org <mailto:Koha-devel@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
The Plack process can be running without being used by Apache. And some virtual hosts can point to the Plack backend, and some others not. That's not a problem. I'm not familiar to plackup.sh, (at misc/plack) but I think that's what you need to use in your scenario. If I had to choose, I'd go with the packages, building your own from your own branch. That's what I do. Regards El mar., 2 ago. 2016 a las 10:36, Philippe Blouin (< philippe.blouin@inlibro.com>) escribió:
haaaa,
No, got git setups. Any instructions on that? two lines maybe? one? :-) Was wondering actually if having plack for one install on 16.05 would break another installation on 3.20 sharing apache. Most things Apache are secluded by virtual host, but some are global. I live in fear...
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 09:27 AM, Tomas Cohen Arazi wrote:
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@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@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> <koha-devel-bounces@lists.koha-community.org> namens Philippe Blouin <philippe.blouin@inlibro.com> <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 | <http://www.inLibro.com>www.inLibro.com
_______________________________________________ Koha-devel mailing list Koha-devel@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
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
participants (5)
-
Jonathan Druart -
Kyle Hall -
Marcel de Rooy -
Philippe Blouin -
Tomas Cohen Arazi