Re: SQL-Map / CDATA Performance Issue

2009-02-01 Thread Kai Grabfelder
-docs/en/ 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 / CDATA Performance Issue

Re: SQL-Map / CDATA Performance Issue

2009-02-01 Thread Nathan Maves
- From: Chema [mailto:demablo...@gmail.com] 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 mggl...@comcast.net

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

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
#,#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-Map / CDATA Performance Issue Here is some more information: 1.) Using (Format

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 mggl...@comcast.net: Looking further into this it seems to have little to do with the CDATA

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
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.apache.org Subject: Re: SQL-Map / CDATA Performance Issue

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

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
/ 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 / CDATA Performance Issue About docs

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 mggl...@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

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
: 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 mggl...@comcast.net: Thanks for your help. I do not see a reference to statementCaching in my