cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <>
Subject [jira] [Created] (CAY-2014) Ensure SelectQuery.setFetchSize() actually takes affect on MySQL
Date Mon, 01 Jun 2015 11:19:17 GMT
Andrus Adamchik created CAY-2014:

             Summary: Ensure SelectQuery.setFetchSize() actually takes affect on MySQL
                 Key: CAY-2014
             Project: Cayenne
          Issue Type: Improvement
            Reporter: Andrus Adamchik
            Assignee: Andrus Adamchik

We supported SelectQuery.setFetchSize() since times immemorial, however it doesn't do much
on MySQL. According to [1] MySQL still reads the entire ResultSet in memory. So whenever a
query has fetch size set, we need to ensure that MySQL adapter creates PreparedStatement using
the following parameters (also from [1]) :

{noformat}stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,

For a bonus point, we'll need to research whether other DBs (PostgreSQL, Oracle, SQLServer)
actually support fetch size or whether they require special handling like MySQL.


This message was sent by Atlassian JIRA

View raw message