<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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.<br>
<br>
But following everyone's comments, ll look into 14478, plack... and
simply moving everything to 16.05 :)<br>
<br>
Any good doc on plack? I got
<a class="moz-txt-link-freetext" href="https://wiki.koha-community.org/wiki/Plack">https://wiki.koha-community.org/wiki/Plack</a>, but 5 lines aren't much,
not even a clue what <instance> is :)<br>
<br>
Thanks everyone!<br>
<br>
<br>
<div class="moz-signature">
<style type="text/css">
.moz-signature {
color: #FFFFFF;
}
.sig_inlibro {
padding-top : 2px;
color: #888888;
font-family : "Trebuchet MS", verdana;
font-size: 90%;
}
.sig_content {
border-top: 2px solid #DDDDDD;
border-bottom: 2px solid #BFD13D;
background-color : #F6F6F6;
padding-left:10px;
}
.sig_inlibro a:visited, .sig_inlibro a:hover, .sig_inlibro a:link {
text-decoration: none;
color: #005B85;
}
.nom {
color: #005B85;
font-weight : bold;
}
.inlibro, .in {
color: #BFD13D;
}
.libro {
color: #005B85;
}
.in, .libro {
font-size : 120%;
}
.desc {
margin-bottom: 0;
padding-bottom: 5px;
}
.small {
font-size: 80%;
}
.tagline {
color : #00BCE4;
}
.sig_footer {
padding-left : 10px;
background-color : #EEEFEA;
}
</style>
<div class="sig_inlibro">
<div class="sig_content"> <span class="nom">Philippe Blouin,</span><br>
<span class="tagline small">Responsable du développement
informatique</span><br>
<p class="desc small"> Tél. : (888) 604-2627<br>
<a href="mailto:philippe.blouin@inLibro.com">philippe.blouin@inLibro.com</a>
</p>
</div>
<div class="sig_footer"> <span class="in">in</span><span
class="libro">Libro</span> <span class="tagline small">|
pour esprit libre |</span> <a class="small"
href="http://www.inLibro.com">www.inLibro.com</a> </div>
</div>
</div>
<div class="moz-cite-prefix">On 08/02/2016 05:30 AM, Marcel de Rooy
wrote:<br>
</div>
<blockquote
cite="mid:VI1PR0501MB25919FF40D2BAA080FFEEC29CE050@VI1PR0501MB2591.eurprd05.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Philippe,</p>
<p>Are you using Jessie or Wheezy ?</p>
<p>I have seen some interesting performance differences between
the versions of DBIx shipped with these Debian versions.</p>
<p>Jessie is much faster.</p>
<p><br>
</p>
<p>Marcel<br>
</p>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt"
face="Calibri, sans-serif" color="#000000"><b>Van:</b>
<a class="moz-txt-link-abbreviated" href="mailto:koha-devel-bounces@lists.koha-community.org">koha-devel-bounces@lists.koha-community.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:koha-devel-bounces@lists.koha-community.org"><koha-devel-bounces@lists.koha-community.org></a> namens
Philippe Blouin <a class="moz-txt-link-rfc2396E" href="mailto:philippe.blouin@inlibro.com"><philippe.blouin@inlibro.com></a><br>
<b>Verzonden:</b> maandag 1 augustus 2016 22:30:14<br>
<b>Aan:</b> <a class="moz-txt-link-abbreviated" href="mailto:koha-devel@lists.koha-community.org">koha-devel@lists.koha-community.org</a><br>
<b>Onderwerp:</b> [Koha-devel] How long is a call to schema()
supposed to take</font>
<div> </div>
</div>
<div>Hello Koha developpers!<br>
<br>
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.<br>
<br>
In C4/Circulation.pm/<b>AddIssue</b>, a lot of transactions take
>1s for the call to schema $issue =
<br>
<br>
Koha::Database->new()-><u><b>schema()</b></u>->resultset('Issue')->create(<br>
<br>
This is <b>3.20</b>. 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?<br>
<br>
Thanks,<br>
<div class="moz-signature">-- <br>
<style type="text/css">
.moz-signature {
color: #FFFFFF;
}
.sig_inlibro {
padding-top : 2px;
color: #888888;
font-family : "Trebuchet MS", verdana;
font-size: 90%;
}
.sig_content {
border-top: 2px solid #DDDDDD;
border-bottom: 2px solid #BFD13D;
background-color : #F6F6F6;
padding-left:10px;
}
.sig_inlibro a:visited, .sig_inlibro a:hover, .sig_inlibro a:link {
text-decoration: none;
color: #005B85;
}
.nom {
color: #005B85;
font-weight : bold;
}
.inlibro, .in {
color: #BFD13D;
}
.libro {
color: #005B85;
}
.in, .libro {
font-size : 120%;
}
.desc {
margin-bottom: 0;
padding-bottom: 5px;
}
.small {
font-size: 80%;
}
.tagline {
color : #00BCE4;
}
.sig_footer {
padding-left : 10px;
background-color : #EEEFEA;
}
</style>
<div class="sig_inlibro">
<div class="sig_content"><span class="nom">Philippe Blouin,</span><br>
<span class="tagline small">Responsable du développement
informatique</span><br>
<p class="desc small">Tél. : (888) 604-2627<br>
<a moz-do-not-send="true"
href="mailto:philippe.blouin@inLibro.com">philippe.blouin@inLibro.com</a>
</p>
</div>
<div class="sig_footer"><span class="in">in</span><span
class="libro">Libro</span>
<span class="tagline small">| pour esprit libre |</span> <a
moz-do-not-send="true" class="small"
href="http://www.inLibro.com">
<a class="moz-txt-link-abbreviated" href="http://www.inLibro.com">www.inLibro.com</a></a> </div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>