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 > >
