ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: SQL-Map / CDATA Performance Issue
Date Sat, 31 Jan 2009 22:39:26 GMT
Do you have statememnt logging enabled?

On 1/31/09, MGG List Subscription <mgglist@comcast.net> wrote:
> When I format the SQL within my insert element like Example 1.0 and time
> several application calls the performance is degraded *substantially*.
> However, if I format the SQL as shown in Example 1.1 the performance
> improves dramatically.
>
> It seems the larger the SQL statement and the more "pretty" formatting that
> is applied to the embedded SQL statement causes the performance to degrade.
> I have read the manual sections on applying the CDATA XML tag to the SQL but
> it seems to not make a difference unlsess the SQL is compacted on to one
> line.
>
> Thank you in advance for any help!
>
> Example 1.0:
>
> <insert id="insertPerson" parameterClass="springibatis.Person">
> 	<![CDATA[
>       	INSERT INTO people (
>             	last_name,
>                   first_name,
>                   age
>                 ) VALUES (
>                   #lastName#,
>                   #firstName#,
>                   #age#
>                 );
>         ]]>
>     </insert>
>
>
> Example 1.1:
>
> <insert id="insertPerson" parameterClass="springibatis.Person">
> 	<![CDATA[
>       	INSERT INTO people (last_name, first_name, age) VALUES (#lastName#,
> #firstName#, #age#);
> 	]]>
> </insert>
> No virus found in this outgoing message.
> Checked by AVG - www.avg.com
> Version: 8.0.233 / Virus Database: 270.10.16/1926 - Release Date: 01/30/09
> 17:31:00
>
>

-- 
Sent from my mobile device

Mime
View raw message