<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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>
</body>
</html>