ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wiwohka <sachin.solk...@fmr.com>
Subject Setting fetchSize
Date Mon, 10 Mar 2008 18:26:31 GMT

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.


Mime
View raw message