Return-Path: <RDorich@intralinks.com>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Delivered-To: moderator for ibatis-user-java@incubator.apache.org
Received: (qmail 94076 invoked by uid 99); 11 Jan 2005 15:59:27 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=HTML_40_50,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from Unknown (HELO ilnxmail2.intralinks.com) (12.110.141.5)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 11 Jan 2005 07:59:26 -0800
To: ibatis-user-java@incubator.apache.org
Subject: Are IBatis dynamic queries cached on the server side?
MIME-Version: 1.0
X-Mailer: Lotus Notes Release 5.0.11   July 24, 2002
Message-ID: 
 <OF371DC250.78F065BB-ON85256F86.005799D9-85256F86.0057D647@intralinks.com>
From: Roberto Dorich <RDorich@intralinks.com>
Date: Tue, 11 Jan 2005 10:59:24 -0500
X-MIMETrack: Serialize by Router on IntraMail_MA_01/Intralinks_NY(Release
 6.0.4|June 01, 2004) at
 01/11/2005 10:59:26 AM,
	Serialize complete at 01/11/2005 10:59:26 AM
Content-Type: multipart/alternative;
 boundary="=_alternative 0057D64385256F86_="
X-Virus-Checked: Checked

This is a multipart message in MIME format.
--=_alternative 0057D64385256F86_=
Content-Type: text/plain; charset="us-ascii"

I assume you use Preparedstatments querying the DB.  As I understand from 
my DBA, it is important to cache these prepared statments to make Oracle 
faster.  Could you let me know if IBatis caches these?
        1.  static (i.e. simple SQL queries)
        2.  dynamic (i.e. queries that get modified with isEqual, etc

If so, where is it documented?

Thank you,

- Roberto

--=_alternative 0057D64385256F86_=
Content-Type: text/html; charset="us-ascii"


<br><font size=2 face="sans-serif">I assume you use Preparedstatments querying the DB. &nbsp;As I understand from my DBA, it is important to cache these prepared statments to make Oracle faster. &nbsp;Could you let me know if IBatis caches these?</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; 1. &nbsp;static (i.e. simple SQL queries)</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; 2. &nbsp;dynamic (i.e. queries that get modified with isEqual, etc</font>
<br>
<br><font size=2 face="sans-serif">If so, where is it documented?</font>
<br>
<br><font size=2 face="sans-serif">Thank you,</font>
<br>
<br><font size=2 face="sans-serif">- Roberto</font>
<br>
--=_alternative 0057D64385256F86_=--