> (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 <[EMAIL PROTECTED]> 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> >
