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

2005-05-25 Thread Abdullah Kauchali
Fabrizio Gianneschi wrote: The Microsoft JDBC driver for SQLServer is ***very*** buggy. We haven't had any serious performance problems with MS JDBC. Could this be the nvarchar unicode issue? http://groups.google.co.za/group/microsoft.public.sqlserver.jdbcdriver/browse_thread/thread/c11b5

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

2005-05-25 Thread Fabrizio Gianneschi
  Thank you all for your input.   Brian 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 an

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.
ssage-From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 12:30 PMTo: ibatis-user-java@incubator.apache.orgSubject: Re: Query performs differently in SQL Query Analyzer>>Each time it encounters a new query?Let's define new query:SELECT * FROM STUDENT WHERE

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

Query performs differently in SQL Query Analyzer

2005-05-23 Thread Barnett, Brian W.
I have a query that returns in 3 or 4 seconds when I run it in Microsoft SQL Query Analyzer but takes over a minute to return when run through iBATIS. Can anyone give me some clues as to what I should check? Here is the SQL Map stuff: