<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: jbpm 3 and getVariable : application slowness
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/vchmakov">vchmakov</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/745128#745128">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><span style="color: #000000; mso-ansi-language: EN-US;"><p><span style="font-family: Calibri;"><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">Hi,</span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;"> </span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">Well, first of all you are asking jBPM 3 question. As to my knowledge jBPM 3 has been transformed into Activiti and moved out. jBPM 5 is a completely new product and is rooting from the Drools. <span style="mso-spacerun: yes;"> </span>I can be wrong on this, so forgive me if I am. </span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">Secondly, your question mostly relates to how Hibernate works/performs. Our company currently working with jBPM 5.2 and we had problems with some SQLs containing in orm.xml files coming with jBPM. The SQL’s are less then optimal and Firebird DB is dying executing them. But it is not jBPM but Hibernate (and perhaps Firebird). Our approach was to not using “bad” SQLs but write our own optimized SQLs and execute them via Hibernate’s Native Query mechanisms. </span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">As to jBPM 5 performance - we do not have any complains so far.</span></p><span style="font-family: Calibri;"><p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;"> </span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">Hope this helps.</span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;"> </span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">Thanks,</span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;"> </span></p><p class="MsoNormal" style="margin: 0cm 0cm 0pt;"><span style="font-size: 12pt; mso-ansi-language: EN-US;">Vladimir</span></p><p class="MsoNormal" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></p></span></span></p></span></p><p><p class="MsoNormal" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p></p><p class="MsoNormal" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div class="mcePaste" id="_mcePaste" style="position: absolute; top: 0px; left: 0px;"></div></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/745128#745128">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>