ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Performance & SQL Formatting Issue
Date Wed, 04 Feb 2009 00:16:30 GMT
Thanks for running these tests Jeff....

I'll roll back the change I made unless it's confirmed that formatting
is an issue.

Clinton



On Tue, Feb 3, 2009 at 4:37 PM, Jeff Butler <jeffgbutler@gmail.com> wrote:
> I'll take that challenge! :)
>
> In the test as distributed, each insert is a new transaction so there
> is no statement caching.
>
> I reran the test making all the inserts into one transaction - and
> then with and without statement caching enabled.  As you might
> imaging, the performance was far superior - about 1.5 seconds for each
> set of 10,000 inserts.  Again, no noticeable difference between
> formatted and unformatted SQL.  The statement cache did knock off
> about 0.2 seconds off execution time - I guess that's a good
> improvement.
>
> The point for me is that the formatting of the SQL has nothing to do
> with performance.  The difference was whether each insert was a
> separate transaction, or whether there was one transaction for all
> inserts.
>
> Interesting - I see about the same vast difference in performance as
> reported by M Goodal, but the difference is the transactional
> configuration - NOT the format of the SQL.
>
> Jeff Butler
>
>
> On Tue, Feb 3, 2009 at 4:49 PM, Chema <demablogia@gmail.com> wrote:
>> I'm sorry to ask it again :
>>
>> about PerformanceTest.java by Jeff , all inserts inside loop are
>> executed in same thread
>>
>> I guess first one is cached into statement cache, isn't it ?
>> So, this test wouldn't be right because text formatting is performed
>> only one time.
>>
>> If I'm wrong in my concept about working of statement cache, please, tell me
>>
>> Thanks and regards
>>
>>
>>
>

Mime
View raw message