JDBCDataStore should fetch data in batches
------------------------------------------

                 Key: GEOT-2004
                 URL: http://jira.codehaus.org/browse/GEOT-2004
             Project: GeoTools
          Issue Type: Improvement
          Components: data h2
    Affects Versions: 2.5.0, 2.6-M0
            Reporter: Andrea Aime
             Fix For: 2.5.0, 2.6-M0


The current code does not set a fetch size on reads, on most database this will 
open a client side cursor that will slurp all the results in memory on query 
execution, making the code memory bound. Adding setFetchSize(200) or so 
prevents this.
We may also want to expose the fetch size to the user for better control (the 
user might know that 200 is inappropriate because the single geometry is huge 
or the feature has big clob/blob fields, or something like that).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to