ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Slow stored procedure performance?
Date Sun, 06 Feb 2005 18:36:32 GMT
> (ps: one time I wrote a 94 page stored procedure.... and it was sub
> second. I did not use iBatis at the time)

Man, you're like a self-deprecating comic.  First you admit to using
Maps for your domain model, now you're claiming responsibility for a
94 page stored proc!!!

;-)

On Sun, 06 Feb 2005 11:40:40 -0600, Vic Cekvenich <vin@friendvu.com> wrote:
> 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