ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: Performance & SQL Formatting Issue
Date Tue, 03 Feb 2009 23:37:22 GMT
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

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

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

View raw message