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>

Reply via email to