<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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 face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Van:</b> koha-devel-bounces@lists.koha-community.org <koha-devel-bounces@lists.koha-community.org> namens Philippe Blouin <philippe.blouin@inlibro.com><br>
<b>Verzonden:</b> maandag 1 augustus 2016 22:30:14<br>
<b>Aan:</b> koha-devel@lists.koha-community.org<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 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>
</body>
</html>