ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From netsql <net...@roomity.com>
Subject Re: Slow query update...
Date Thu, 28 Jul 2005 02:03:27 GMT
You can allways do a stored proc and force a plan.

The querry optimizer should see the querry the same way.
.V

Greg Day wrote:
> Hi all
> 
> regarding my ultra-slow query when running through ibatis..
> just to recap, if I run a sybase query through Ibatis (inside jboss), it 
> goes really slow, if I run it through jdbc (inside jboss) its quick.
> 
> The query is essentially a select * by unique identifier (which has an 
> index).
> 
> Basically, the database is doing a table scan on this table when the 
> query is run through ibatis. It doesnt do the table scan when its run 
> through jdbc.
> 
> So, my question is: what is ibatis doing here? are there hints that it 
> gives to sybase that tells it something about query plans? im very 
> confused...
> 
> any help would be much appreciated.
> 
> Thanks
> Greg
> 


-- 

.V

People are conversing... without posting their email or filling up their
mail box.
roomity.com <http://roomity.com/launch.jsp>

No sign up to read or search this Rich Internet App.


Mime
View raw message