<div dir="ltr"><div><div><div><div><div>$BBgCf$G$9!#(B<br><br>[Seasar-user:21321] Re: FetchHandler$B$K$D$$$F(B<br><a href="https://ml.seasar.org/archives/seasar-user/2012-April/021324.html">https://ml.seasar.org/archives/seasar-user/2012-April/021324.html</a><br>

<br>$B$J$s$G$9$,!"Hs(BSeasar$B0F7o$J$s$G$9$,$=$3$G$o$+$C$?$3$H$,$"$C$?$N$G!"(B<br>$B>pJsDs6!$7$^$9!#(B<br><br></div>PostgreSQL$B$N>l9g!"(B Statement#setFetchSize $B$r;XDj$7$J$$$H!"(B<br></div>ResultSet$B$OA47o<hF@$9$k$H$$$&$N$,;EMM$N$h$&$G$9!#(B<br></div><br>$B;29M(B<br><a href="http://stackoverflow.com/questions/3682614/jdbc-how-to-read-all-rows-from-huge-table">http://stackoverflow.com/questions/3682614/jdbc-how-to-read-all-rows-from-huge-table</a><br>

<a href="http://jdbc.postgresql.org/documentation/84/query.html#fetchsize-example">http://jdbc.postgresql.org/documentation/84/query.html#fetchsize-example</a><br><br>$B$J$N$G!"7o?t$,KD$i$`>l9g$O!"(BsetFetchSize $B$7$F$d$i$J$$$H!"(BOOME$B$N(B<br>$B860x$K$J$j$^$9!#(B<br>

<br></div>S2Dao$B$O(BfetchSize$B$,(Bjdbc.dicon$B$G0l3g;XDj$J$N$GG:$^$7$$$s$G$9$,!"(B<br></div>S2JDBC/Doma$B$O!"$=$l$>$l;XDj$9$k8}$,$"$k$N$G!"$3$l$r;H$($l$P(B<br>$B$$$1$k$s$8$c$J$$$+$H;W$$$^$9!#(B<br><br></div>