RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
I downloaded this documentation from the website. I am assuming since it's the only Developers Guide available on the website that it was the latest version. Am I mistaken? Where can I get the latest version of the docs? -Original Message- From: Chema [mailto:demablo...@gmail.com] Sent: Sa

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
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 > version of the docs. > > See: > http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/ > iBATIS-SqlMaps-2_en

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
Thanks for your help. I do not see a reference to statementCaching in my version of the docs. See: http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/ iBATIS-SqlMaps-2_en.pdf Is there more recent docs available other than the ones I have? -Original Message- From:

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
About docs: statementCachingEnabled (iBATIS versions 2.3.0 and later) With this setting enabled, iBATIS will maintain a local cache of prepared statements. This can lead to significant performance improvements. Example: statementCachingEnabled="true" Default: true (enabled) I asked you this quest

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
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! M. Goodell -Original Message- From: Chema [mailto:demablo...@gmail.com] Sent: Sa

Re: SQL-Map / CDATA Performance Issue

2009-01-31 Thread Chema
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 > but the formatting of the SQL statement. The more formatting applied to the > SQL statement, the slower the performance. > > F

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
Looking further into this it seems to have little to do with the CDATA tag but the formatting of the SQL statement. The more formatting applied to the SQL statement, the slower the performance. Format A is much slower than Format A (Format A) INSERT INTO people ( last_name,

RE: SQL-Map / CDATA Performance Issue

2009-01-31 Thread M. Goodell
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 this takes roughly 7-8 seconds. (Format B) INSERT INTO people ( last_name, first_name, age ) V

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