Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.146.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=BD5WSbsLsyXVj6UAMNt4LwJgGxj7HgFxUbt3QcsGZA9xoqFYmG6rE+W0bBOepaB7y2
         8S3wBgGef+HSNjbVTyzvPJ5jcO9c2htsbSycdF+hwF6p4ASxjsfvycZ9C5zBLjeI+R0l
         9b7gQiQBUMkMJUfweMJPo1vIYwJ30R+uBikh8=
MIME-Version: 1.0
In-Reply-To: <c593b8750902031537u53538b19vec68c7ed1b15c5b8@mail.gmail.com>
References: <006701c98566$cae6ede0$60b4c9a0$@com>
	 <16178eb10902021141p3146f89bg8274489cdeb07c0f@mail.gmail.com>
	 <001a01c9861d$0def2600$29cd7200$@com>
	 <49887AF0.40403@kaigrabfelder.de>
	 <16178eb10902031214s68e7dbeau1998849ebe19b7bf@mail.gmail.com>
	 <c593b8750902031414h427f09a0kccf2896b42ae075e@mail.gmail.com>
	 <55efbd800902031449v694b2cbbh9edb70249a239ee3@mail.gmail.com>
	 <c593b8750902031537u53538b19vec68c7ed1b15c5b8@mail.gmail.com>
Date: Tue, 3 Feb 2009 17:16:30 -0700
Message-ID: <16178eb10902031616k7f139876j3e8cd4a46f41f802@mail.gmail.com>
Subject: Re: Performance & SQL Formatting Issue
From: Clinton Begin <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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
>>
>>
>>
>