Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of jeffgbutler@gmail.com designates
 66.249.92.169 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=rMaso3xF8NZTe55sRDjqvK3Kp/kArMaWRaDb/sIp8X7SgDV602UpKumzxpcRIQg9syKPAe8h1MLB/2nColy+usnEQNQ7sCdbbCwJSOl47qsPofxk6DFBg6QuVbsjQoKJXVIW8fIYrFNW7KCp2+V3Wq8B8t8dIa1E+YaC/cHdJAc=
Message-ID: <c593b8750608021232p3bc8b2d0v6ef1b26f2f6323a6@mail.gmail.com>
Date: Wed, 2 Aug 2006 14:32:42 -0500
From: "Jeff Butler" <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Is PreparedStatement reused on insert?
In-Reply-To: <3A68DD30-AEB5-4086-925F-30FA16C67F46@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_127252_25029821.1154547162963"
References: <3A68DD30-AEB5-4086-925F-30FA16C67F46@gmail.com>

------=_Part_127252_25029821.1154547162963
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

If you use a batch, then the prepared statement will be reused.  The latest
developer guide has lots of information about batches.

Jeff Butler


On 8/2/06, Kenji Nakamura <nakamura.kenji@gmail.com> wrote:
>
> Hi,
>
> I'm evaluating iBatis 2.1.7, and encountered a performance problem.
> The benchmark is simply taking a sequential file with approximately
> 16,000 lines, and populate them into HSQLDB (1.8.0.1) with 20 lines
> of batch. I see iBatis version is two to three times slower than
> plain vanilla JDBC version.
> I put a profiler, and it indicates
> com.ibatis.sqlmap.engine.execution.SqlExecutor#excuteUpdate() creates
> an instance of PreparedStatement every time calling
> SqlMapClient#insert(), and it is actually created at line 77 of the
> method.
> Is there a way to keep an instance of PreparedStatement for an Id and
> reuse it? At least creation of PreparedStatement isn't a cheap
> operation in HSQLDB, which takes up 51% of whole execution time in my
> benchmark.
>
> Thanks in advance,
>
> Kenji
>
>

------=_Part_127252_25029821.1154547162963
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>If you use a batch, then the prepared statement will be reused.&nbsp; The latest developer guide has lots of information about batches.</div>
<div>&nbsp;</div>
<div>Jeff Butler</div>
<div><br><br>&nbsp;</div>
<div><span class="gmail_quote">On 8/2/06, <b class="gmail_sendername">Kenji Nakamura</b> &lt;<a href="mailto:nakamura.kenji@gmail.com">nakamura.kenji@gmail.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,<br><br>I'm evaluating iBatis 2.1.7, and encountered a performance problem.<br>The benchmark is simply taking a sequential file with approximately
<br>16,000 lines, and populate them into HSQLDB (<a href="http://1.8.0.1">1.8.0.1</a>) with 20 lines<br>of batch. I see iBatis version is two to three times slower than<br>plain vanilla JDBC version.<br>I put a profiler, and it indicates
<br>com.ibatis.sqlmap.engine.execution.SqlExecutor#excuteUpdate() creates<br>an instance of PreparedStatement every time calling<br>SqlMapClient#insert(), and it is actually created at line 77 of the<br>method.<br>Is there a way to keep an instance of PreparedStatement for an Id and
<br>reuse it? At least creation of PreparedStatement isn't a cheap<br>operation in HSQLDB, which takes up 51% of whole execution time in my<br>benchmark.<br><br>Thanks in advance,<br><br>Kenji<br><br></blockquote></div><br>

------=_Part_127252_25029821.1154547162963--