Trying to set fetchSize on calls to stored procedure in the SQL mapping file
-
<procedure id="get" parameterMap="get-param-map" fetchSize="100">
{call pkg.get_data(?,?,?,?,?, ?,?,?,?,?, ?,?)}
</procedure>
But does not seem to affect. Smaller result set like 10 rows has better
performance than larger result set like say 95 rows. This is with iBATIS
2.3.0, Oracle 10g, ojdbc14 driver.
Any pointers?
Thanks.
--
View this message in context:
http://www.nabble.com/Setting-fetchSize-tp15951032p15951032.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
