Optimize result set fetches for stored procs
--------------------------------------------
Key: IBATIS-308
URL: http://issues.apache.org/jira/browse/IBATIS-308
Project: iBatis for Java
Type: Improvement
Components: SQL Maps
Versions: 2.0.8, 2.0.9, 2.1.0, 2.0.9b, 2.1.5, 2.1.6, 2.1.7
Environment: Applicable to any
Reporter: Amit Kushwaha
Executing queries contained in stored procedures, optimize result set fetches
if the fetch size on the Statement(BaseStatement) is specified. This will
improve performance by getting multiple records out from the database per round
trip as specified by the fetch size. Some drivers have a default fetch value,
for example, Oracle set's the fetch size to 10 by default. And overriding the
default fetch size if useful in cases when the SQL query executed returns a
large number of rows.
At the moment, its possible to set the fetch size on the BaseStatement. And it
takes effect while executing the query using a PreparedStatement but not on a
CallableStatement. So in SqlExecutor, in executeQueryProcedure, we should set
the fetch size on the CallableStatement, if a fetch size is specified on the
BaseStatement as is done in the executeQuery method.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
