Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of jeffgbutler@gmail.com
 designates 209.85.217.11 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=mKG7e0ZEZya/Yos0pW3Wlm3Q6oL+ACdXnzapz/butqad9HR8TuJXV68ZbTOilCHcXV
         QFy6TuQXfyuh0ddtujfFhWHOggM57oP0/6D8enHsSiv5l17Gi8H9PAbVlzJRysQBCBal
         vD53OfcHFi2BH0IGAl0293JpLNVTL4/XPLt18=
Message-ID: <c593b8750901050746l42121e2aw4cae2533aa4b2806@mail.gmail.com>
Date: Mon, 5 Jan 2009 09:46:22 -0600
From: "Jeff Butler" <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org, asethi_im@yahoo.com
Subject: Re: Dynamic Query and Prepared Statement Caching
In-Reply-To: <622690.19073.qm@web59814.mail.ac4.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <622690.19073.qm@web59814.mail.ac4.yahoo.com>

iBATIS does cache prepared statements.  The cache is based on the SQL
string that is created after the dynamic query is resolved.  So if you
have 300 different combinations of criteria, then you will have 300
cached prepared statements.

Jeff Butler


On Sun, Jan 4, 2009 at 9:01 PM, Anurag Sethi <asethi_im@yahoo.com> wrote:
> Hi,
> I am using the Abator generated queryByExample sql/DAO classes. I am specifically using the Criteria class in there and have a bunch of criteria ored in the example that I send as the parameter.
>
> So in general, I have the actual query with different number of criteria ored.
>
> Does Ibatis cache the resulting Prepared statements too? If not, what is the best way to make sure that the statements are not prepared every time the queryByExample interface is called. Its a big performance hit.
>
> I have also tried generating an sql map programatically as part of the bootstrap sequence and actually put in around 300 different static queries in there and call the one based on the number of criteria I would have had to or using the queryByExample dynamic query. This should at-least lead to caching of the prepared statements. Please correct me if I am wrong.
>
> Thanks,
> Anurag
>
>
>
>
>