This is an automated email from the ASF dual-hosted git repository. ntimofeev pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/cayenne-website.git
The following commit(s) were added to refs/heads/master by this push: new c797bbf Update 4.1 docs c797bbf is described below commit c797bbf5cfb18a69d0724fa0d24ecb2316488716 Author: Nikita Timofeev <stari...@gmail.com> AuthorDate: Wed Jul 22 12:46:53 2020 +0300 Update 4.1 docs --- src/main/site/content/docs/4.1/cayenne-guide.html | 23 +++++++++++++++++++++-- 1 file changed, 21 insertions(+), 2 deletions(-) diff --git a/src/main/site/content/docs/4.1/cayenne-guide.html b/src/main/site/content/docs/4.1/cayenne-guide.html index 96e5524..02ee853 100644 --- a/src/main/site/content/docs/4.1/cayenne-guide.html +++ b/src/main/site/content/docs/4.1/cayenne-guide.html @@ -60,7 +60,7 @@ menu: <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">4.1</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Java 1.8 or newer</p></td> - <td class="tableblock halign-left valign-top"><p class="tableblock">Beta</p></td> + <td class="tableblock halign-left valign-top"><p class="tableblock">Stable</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">4.0</p></td> @@ -70,7 +70,7 @@ menu: <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">3.1</p></td> <td class="tableblock halign-left valign-top"><p class="tableblock">Java 1.5 or newer</p></td> - <td class="tableblock halign-left valign-top"><p class="tableblock">Stable</p></td> + <td class="tableblock halign-left valign-top"><p class="tableblock">Aging</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">3.0</p></td> @@ -2490,6 +2490,25 @@ for(DataRow row : rows) { }</code></pre> </div> </div> + <div class="sect4"> + <h5 id="mysql-jdbc-driver-and-iterated-queries"><a class="anchor" href="#mysql-jdbc-driver-and-iterated-queries"></a>2.8.4.1. MySQL JDBC driver and iterated queries</h5> + <div class="paragraph"> + <p>The MySQL JDBC driver is known to pull the entire ResultSet into memory. In order to get the driver to stream the results, append the JDBC parameter <code>useCursorFetch=true</code> to the JDBC URL.</p> + </div> + <div class="paragraph"> + <p>A fetch size must also be set when doing the query using <code>ObjectSelect.statementFetchSize(..)</code>, for example:</p> + </div> + <div class="listingblock"> + <div class="content"> + <pre class="highlight"><code class="language-java java" data-lang="java">ObjectSelect.query(queryClass) + .statementFetchSize(50000) + .iterate(objectContext, cayenneObject -> ...</code></pre> + </div> + </div> + <div class="paragraph"> + <p>Adjust the value of the fetch size to fit requirements. A larger value is more performant, but consumes more memory as well.</p> + </div> + </div> </div> <div class="sect3"> <h4 id="paginated-queries"><a class="anchor" href="#paginated-queries"></a>2.8.5. Paginated Queries</h4>