ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vic Cekvenich <...@friendvu.com>
Subject Re: Slow stored procedure performance?
Date Sun, 06 Feb 2005 17:40:40 GMT
Clinton Begin wrote:

>> Same parameters, same load on DB, everything.  Very
>>reproducable.  Does anyone have any tips on what might be happening?
Can you do even more in the sored procedure itself... and let SQL map 
deal with the mapping of results only?
Also... sometimes "with recompile" in sql will help pick a good 
execution path.

All guesses....

(ps: one time I wrote a 94 page stored procedure.... and it was sub 
second. I did not use iBatis at the time)

Forums, Boards, Blogs and News in RiA <http://www.boardVU.com>

View raw message