Here is some more information:
1.) Using (Format A) and inserting 10,000 records this takes roughly 12-15
seconds.
(Format A)
<![CDATA[
INSERT INTO people (
last_name,
first_name,
age
) VALUES (
#lastName#,
#firstName#,
#age#
);
]]>
2.) Using (Format B) and inserting 10,000 records this takes roughly 7-8
seconds.
(Format B)
INSERT INTO people (
last_name,
first_name,
age
) VALUES (
#lastName#,
#firstName#,
#age#
);
3.) Using (Format C) and inserting 10,000 records this takes roughly 3-4
seconds.
(Format C)
INSERT INTO people (last_name, first_name, age) VALUES
(#lastName#,#firstName#,#age#);
Again, thanks for any help.
-----Original Message-----
From: Chema [mailto:[email protected]]
Sent: Saturday, January 31, 2009 12:24 PM
To: [email protected]; [email protected]
Subject: Re: SQL-Map / CDATA Performance Issue
And without CDATA tag ? Same performance ?
Indeed, I don't know why you use it for that query
2009/1/31 MGG List Subscription <[email protected]>:
> 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
>
>
No virus found in this incoming 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
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
