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....

.V
(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>

Mime
View raw message