Re: SQL-Map / CDATA Performance Issue

2009-02-01 Thread Nathan Maves
t > > version. Am I mistaken? Where can I get the latest version of the docs? > > > > -Original Message- > > From: Chema [mailto:demablo...@gmail.com] > > Sent: Saturday, January 31, 2009 2:18 PM > > To: user-java@ibatis.apache.org > > Subject: Re: SQL

Re: SQL-Map / CDATA Performance Issue

2009-02-01 Thread Kai Grabfelder
t; Version: ibatis-2.3.4.726 >>> >>> Not using statement caching as far as I know. >>> >>> Could you please provide a brief example of turning on statement caching? >> I >>> have read without it there is a performance hit. >>> >>> Thanks!

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
Sent: Saturday, January 31, 2009 2:18 PM To: user-java@ibatis.apache.org Subject: Re: SQL-Map / CDATA Performance Issue Yes, yours is old. Mine is dated on November 30, 2006 (2.3.x ) 2009/1/31 M. Goodell : > Thanks for your help. I do not see a reference to statementCaching in my > ver

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Clinton Begin
Do you have statememnt logging enabled? On 1/31/09, MGG List Subscription 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 performan

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
gt; iBATIS-SqlMaps-2_en.pdf > > Is there more recent docs available other than the ones I have? > > -Original Message- > From: Chema [mailto:demablo...@gmail.com] > Sent: Saturday, January 31, 2009 1:54 PM > To: user-java@ibatis.apache.org > Subject: Re: SQL-Map

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
: Chema [mailto:demablo...@gmail.com] Sent: Saturday, January 31, 2009 1:54 PM To: user-java@ibatis.apache.org Subject: Re: SQL-Map / CDATA Performance Issue About docs: statementCachingEnabled (iBATIS versions 2.3.0 and later) With this setting enabled, iBATIS will maintain a local cache of

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
brief example of turning on statement caching? I > have read without it there is a performance hit. > > Thanks! > > M. Goodell > > -Original Message- > From: Chema [mailto:demablo...@gmail.com] > Sent: Saturday, January 31, 2009 1:12 PM > To: user-java@ibatis.a

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
: Saturday, January 31, 2009 1:12 PM To: user-java@ibatis.apache.org Subject: Re: SQL-Map / CDATA Performance Issue What version are you using ? Do you have statement caching enabled ? 2009/1/31 M. Goodell : > Looking further into this it seems to have little to do with the CDATA tag > b

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
NTO people (last_name,first_name,age) VALUES > (#lastName#,#firstName#,#age#); > > -Original Message- > From: M. Goodell [mailto:mggl...@comcast.net] > Sent: Saturday, January 31, 2009 12:52 PM > To: Chema; user-java@ibatis.apache.org; mggl...@comcast.net > Subject: RE: SQL-Ma

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
12:52 PM To: Chema; user-java@ibatis.apache.org; mggl...@comcast.net Subject: RE: SQL-Map / CDATA Performance Issue Here is some more information: 1.) Using (Format A) and inserting 10,000 records this takes roughly 12-15 seconds. (Format A) 2.) Using (Format B) and inserting 10,000 records

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
- From: Chema [mailto:demablo...@gmail.com] Sent: Saturday, January 31, 2009 12:24 PM To: user-java@ibatis.apache.org; mggl...@comcast.net 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

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
And without CDATA tag ? Same performance ? Indeed, I don't know why you use it for that query 2009/1/31 MGG List Subscription : > 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 forma

SQL-Map / CDATA Performance Issue

2009-01-31 Thread MGG List Subscription
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" fo