Improving Plack intranet performances (circulation module)
Hi everyone, Using Devel::NYTProf on a Plack config, I noticed that when we checkout an item in the circulation page, there is a really long time spent creating the database schema. By adding the import of *Koha::Schema* in the *intranet.psgi* file, we can see a significant improvement of the time spent loading the circulation page. Please find here <http://www.slideshare.net/JulianFiol/koha-circulation-checkout-improvement> (in full screen) the proof of what I'm saying. I have also added the manipulations to do into the Plack <http://wiki.koha-community.org/wiki/Plack#Improving_Plack_performance> wiki. Regards, Julian FIOL
Julian FIOL schreef op wo 27-05-2015 om 12:14 [+0200]:
By adding the import of Koha::Schema in the intranet.psgi file, we can see a significant improvement of the time spent loading the circulation page.
Somewhere on a giant TODO-unless-someone-does-it-first list I have in my head is a plan to make packages that use plack instead of CGI. Probably a package you can install alongside Koha and it converts all the files to support plack (Debian has a handy thing that lets you redirect files that'd make this a lot easier - install the package and it's plack, remove the package and it's back to normal.) This is totally the sort of thing that's really good to know as part of implementing that, so all sorts of things like this that you find, please wiki-fy :) Also, Devel::NYTProf is great for this stuff. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Very good news, thanks Le 27/05/2015 12:14, Julian FIOL a écrit :
Hi everyone,
Using Devel::NYTProf on a Plack config, I noticed that when we checkout an item in the circulation page, there is a really long time spent creating the database schema.
By adding the import of *Koha::Schema* in the *intranet.psgi* file, we can see a significant improvement of the time spent loading the circulation page.
Please find here <http://www.slideshare.net/JulianFiol/koha-circulation-checkout-improvement> (in full screen) the proof of what I'm saying.
I have also added the manipulations to do into the Plack <http://wiki.koha-community.org/wiki/Plack#Improving_Plack_performance> wiki.
Regards, Julian FIOL
_______________________________________________ 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/
-- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers@biblibre.com
I resumed my work on automating plack usage on packages installs. News about it soon. 2015-05-28 12:21 GMT-03:00 Fridolin SOMERS <fridolin.somers@biblibre.com>:
Very good news, thanks
Le 27/05/2015 12:14, Julian FIOL a écrit :
Hi everyone,
Using Devel::NYTProf on a Plack config, I noticed that when we checkout an item in the circulation page, there is a really long time spent creating the database schema.
By adding the import of *Koha::Schema* in the *intranet.psgi* file, we can see a significant improvement of the time spent loading the circulation page.
Please find here < http://www.slideshare.net/JulianFiol/koha-circulation-checkout-improvement
(in full screen) the proof of what I'm saying.
I have also added the manipulations to do into the Plack <http://wiki.koha-community.org/wiki/Plack#Improving_Plack_performance> wiki.
Regards, Julian FIOL
_______________________________________________ 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/
-- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers@biblibre.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 Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
It is done. The patches to integrate Plack with the packages are ready. 2015-05-28 12:22 GMT-03:00 Tomas Cohen Arazi <tomascohen@gmail.com>:
I resumed my work on automating plack usage on packages installs. News about it soon.
2015-05-28 12:21 GMT-03:00 Fridolin SOMERS <fridolin.somers@biblibre.com>:
Very good news, thanks
Le 27/05/2015 12:14, Julian FIOL a écrit :
Hi everyone,
Using Devel::NYTProf on a Plack config, I noticed that when we checkout an item in the circulation page, there is a really long time spent creating the database schema.
By adding the import of *Koha::Schema* in the *intranet.psgi* file, we can see a significant improvement of the time spent loading the circulation page.
Please find here < http://www.slideshare.net/JulianFiol/koha-circulation-checkout-improvement
(in full screen) the proof of what I'm saying.
I have also added the manipulations to do into the Plack <http://wiki.koha-community.org/wiki/Plack#Improving_Plack_performance> wiki.
Regards, Julian FIOL
_______________________________________________ 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/
-- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers@biblibre.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 Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
Awesome On Tue, Aug 18, 2015 at 1:11 PM, Tomas Cohen Arazi <tomascohen@gmail.com> wrote:
It is done. The patches to integrate Plack with the packages are ready.
2015-05-28 12:22 GMT-03:00 Tomas Cohen Arazi <tomascohen@gmail.com>:
I resumed my work on automating plack usage on packages installs. News about it soon.
2015-05-28 12:21 GMT-03:00 Fridolin SOMERS <fridolin.somers@biblibre.com> :
Very good news, thanks
Le 27/05/2015 12:14, Julian FIOL a écrit :
Hi everyone,
Using Devel::NYTProf on a Plack config, I noticed that when we checkout an item in the circulation page, there is a really long time spent creating the database schema.
By adding the import of *Koha::Schema* in the *intranet.psgi* file, we can see a significant improvement of the time spent loading the circulation page.
Please find here < http://www.slideshare.net/JulianFiol/koha-circulation-checkout-improvement
(in full screen) the proof of what I'm saying.
I have also added the manipulations to do into the Plack <http://wiki.koha-community.org/wiki/Plack#Improving_Plack_performance> wiki.
Regards, Julian FIOL
_______________________________________________ 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/
-- Fridolin SOMERS Biblibre - Pôles support et système fridolin.somers@biblibre.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 Prosecretaría de Informática Universidad Nacional de Córdoba ✆ +54 351 5353750 ext 13168 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F
_______________________________________________ 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/
-- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com info@bywatersolutions.com
participants (5)
-
Brendan Gallagher -
Fridolin SOMERS -
Julian FIOL -
Robin Sheat -
Tomas Cohen Arazi