I have observed that batch execution of stored procs pretty much takes the same amount of time as executing the procedure in a loop. Warm Regards, Sundar Sankarnarayanan Software Engineer @University of Phoenix
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 22, 2008 9:54 AM To: [email protected] Subject: Re: iBatis-362 - Caching broken for stored procs Is this true? Caching does not work with stored procedures? Is there a work around or is a patch expected? Thanks... Chris "Jason Bennett" <[EMAIL PROTECTED]> 04/17/2008 12:32 PM Please respond to [email protected] To <[email protected]> cc Subject iBatis-362 - Caching broken for stored procs I ran across this bug today, and was surprised that there hasn't been any discussion. As far as I can tell, iBatis caching does not work for stored procedure return values - you always get a null (or empty) value out of the cache. Has anyone else experienced this (or not), and found a workaround? jason
