Re: Query performs differently in SQL Query Analyzer [SOLVED]

2005-05-24 Thread Clinton Begin
inal Message-From: Barnett, Brian W. Sent: Monday, May 23, 2005 2:19 PMTo: 'ibatis-user-java@incubator.apache.org'Subject: RE: Query performs differently in SQL Query Analyzer >>where and when do you build your SqlMapClient instance? We used JPetStore 4 as a

RE: Query performs differently in SQL Query Analyzer [SOLVED]

2005-05-23 Thread Barnett, Brian W.
Barnett -Original Message-From: Barnett, Brian W. Sent: Monday, May 23, 2005 2:19 PMTo: 'ibatis-user-java@incubator.apache.org'Subject: RE: Query performs differently in SQL Query Analyzer >>where and when do you build your SqlMapClient instance? We used JPetSt

RE: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Barnett, Brian W.
I run in Query Analyzer is exactly the same. I pulled it from thelogging, which I turned off after your suggestion, but did not see anoticeable difference.-----Original Message-From: Nathan Maves [mailto: [EMAIL PROTECTED]]Sent: Monday, May 23, 2005 11:19 AMTo: ibatis-user-

Re: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Clinton Begin
t: Monday, May 23, 2005 11:19 AMTo: ibatis-user-java@incubator.apache.orgSubject: Re: Query performs differently in SQL Query Analyzer This truly sound like a sql problem.  Make sure that the sql that isgenerated by ibatis is what you run in your analyzer.On a side note make sure that all logging is turned off for youra

Re: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Brandon Goodin
stion, but did not see a > noticeable difference. > > -Original Message- > From: Nathan Maves [mailto:[EMAIL PROTECTED] > Sent: Monday, May 23, 2005 11:19 AM > To: ibatis-user-java@incubator.apache.org > Subject: Re: Query performs differently in SQL Query Analyzer > >

RE: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Barnett, Brian W.
, which I turned off after your suggestion, but did not see a noticeable difference. -Original Message- From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 11:19 AM To: ibatis-user-java@incubator.apache.org Subject: Re: Query performs differently in SQL Query Analyzer

Re: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Nathan Maves
udent more than once. Suggestions? -Original Message- From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 10:59 AM To: ibatis-user-java@incubator.apache.org Subject: Re: Query performs differently in SQL Query Analyzer I think this needs a FAQ :) This has been cover

RE: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Barnett, Brian W.
From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 10:59 AM To: ibatis-user-java@incubator.apache.org Subject: Re: Query performs differently in SQL Query Analyzer I think this needs a FAQ :) This has been cover quite a few times. iBatis is doing way more then just runnin

Re: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Nathan Maves
I think this needs a FAQ :) This has been cover quite a few times. iBatis is doing way more then just running sql. Make sure that to truly test the performance of iBatis that you run the query multiple times. The initial run is creating many object and sets everything up. Check the spee