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 -&gt; ...</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> 

Reply via email to