ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tuncay Baskan <tbas...@gmail.com>
Subject Re: Slow ibatis query
Date Thu, 21 Jul 2005 21:16:13 GMT
If your database server is SQL Server, Profiler can help to see what
is going to database server.

On 7/22/05, Ed Griebel <edgriebel@gmail.com> wrote:
> You could try using p6spy to see what query(s) iBatis is sending along
> and if it's what you expect.
> 
>  http://www.p6spy.com/
> 
> -ed
> 
> On 7/21/05, Greg Day <Greg.Day@tec.govt.nz> wrote:
> >
> >
> > Hi all
> >
> > I have a strange problem, we are using ibatis as our data access layer, and
> > everything generally goes fine.
> > I recently added a query, which essentially does a "select * from X where
> > primary_key = ?"
> >
> > This query is very fast (300ms) when run externally through a database
> > console, or using jdbc, or using direct jdbc inside jboss. even using the
> > same connection as ibatis. But... when I run it using ibatis, it takes 4-5
> > seconds...
> >
> > now, I stepped through the ibatis code, and everything is fast up to the
> > point of ps.execute (where the prepared statement is executed), then
> > everything stops for 4-5 seconds while the query is executed.
> >
> > Huh? Im doing exactly the same, executing a prepared statement with my jdbc
> > version, so what is going on? Im very confused, I don't even know where to
> > start looking. If anyone has any ideas.... they would be gratefully
> > received.
> >
> > Thanks!
> > Greg
> 


-- 
/tb.

Mime
View raw message