[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #25 from Jonathan Druart --- (In reply to Katrin Fischer from comment #24) > (In reply to David Cook from comment #23) > > Looks like an old one, but I've often wondered why we haven't fetched all > > the system

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #24 from Katrin Fischer --- (In reply to David Cook from comment #23) > Looks like an old one, but I've often wondered why we haven't fetched all > the system preferences at once to avoid subsequent calls to the

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 David Cook changed: What|Removed |Added CC||dc...@prosentient.com.au ---

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #22 from Jacek Ablewicz --- (In reply to Jonathan Druart from comment #21) > (In reply to Jonathan Druart from comment #20) > > Created attachment 56012 [details] [review] [review] > > Bug 15341:

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #21 from Jonathan Druart --- (In reply to Jonathan Druart from comment #20) > Created attachment 56012 [details] [review] > Bug 15341: Retrieve all sysprefs at once Jacek, did

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added Attachment #45535|0

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #19 from Jonathan Druart --- Ok I think I got it: you want to serialise all prefs into the same structure. -- You are receiving this mail because: You are watching all bug

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #18 from Jonathan Druart --- Jacek, sorry this has ran out of my radar. I do not really undertand how this could be (really) useful, the syspref cache is populated when Koha

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Marc Véron changed: What|Removed |Added CC||ve...@veron.ch

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Marcel de Rooy changed: What|Removed |Added CC|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #17 from Jacek Ablewicz --- + retrieving all sysprefs at once directly from the database will be a lot faster too (especially in more recent DBIx version with hashref_inflator involved) -- You

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #16 from Jacek Ablewicz --- Jonathan, I wonder what would you think about resurrecting this bug? Starts to look like a better and better idea to me, it would: - allow to flush all L2 syspref

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jacek Ablewicz changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jacek Ablewicz changed: What|Removed |Added Status|ASSIGNED|In

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added Depends on|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #14 from Jonathan Druart --- (In reply to Jonathan Druart from comment #13) > Something interesting: > > on master: > # spent 35.1ms within DBI::common::DESTROY which was called

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added Blocks|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #13 from Jonathan Druart --- Something interesting: on master: # spent 35.1ms within DBI::common::DESTROY which was called 12520 times, avg 3µs/call with path: # spent 2.54s

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #12 from Jonathan Druart --- Retested today on opac-search: Without the patch (i.e master): 17.0s (of 20.8s), executing 3550368 statements and 1053896 subroutine calls in 421

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Heather Braum changed: What|Removed |Added CC|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #11 from Jonathan Druart --- You can use the one you want. I have just shared the method I use for years now. -- You are receiving this mail because: You are watching all bug

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #8 from Frédéric Demians --- Is there a way to have Plack running without packages? -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #9 from Jonathan Druart --- /etc/apache2/sites-available/koha.conf Order deny,allow Allow from 127.0.0.1,localhost ProxyPass

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #10 from Tomás Cohen Arazi --- Can't we use debian/templates/plack.psgi instead? -- You are receiving this mail because: You are watching all bug changes.

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #4 from Jonathan Druart --- (In reply to Frédéric Demians from comment #2) > Isn't plack supposed to bring some persistency? And so couldn't we have > preferences available

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jacek Ablewicz changed: What|Removed |Added CC|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #7 from Jonathan Druart --- (In reply to Jacek Ablewicz from comment #6) > (In reply to Jonathan Druart from comment #4) > > (In reply to Frédéric Demians from comment #2) > > >

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #5 from Frédéric Demians --- See comment 3. The main issue isn't in preferences by themselves, but in DBIx::Class startup. Let see that:

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #6 from Jacek Ablewicz --- (In reply to Jonathan Druart from comment #4) > (In reply to Frédéric Demians from comment #2) > > Isn't plack supposed to bring some persistency? And so couldn't we have

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added Depends on|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #1 from Jonathan Druart --- Created attachment 45535 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=45535=edit Bug 15341: Retrieve all sysprefs at once

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added Blocks|

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Jonathan Druart changed: What|Removed |Added Status|ASSIGNED

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #3 from Frédéric Demians --- > I can see in NYTProf stats that 1/3 of execution time is spent in > C4::Context::preference. But, this time is in fact spent in Koha::Database::schema, than

[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Frédéric Demians changed: What|Removed |Added CC|