2013/2/20 Andrea Aime <[email protected]>:
> On Wed, Feb 20, 2013 at 12:26 PM, Stefano Iacovella
> <[email protected]> wrote:
>>
>> Hi Andrea,
>>
>> I saw that Oracle JDBC Driver have a setDefaultRowPrefetch() and
>> setRowPrefetch () methods
>>
>> http://slowdog.net/archives/22
>>
>> For the sake of curiosity, do you know if they are used in GeoTools or
>> could you point me to the classes where I can check?
>>
>
> They are not used at all, we are just setting up a DBCP connection pool
> in the most generic way, there is nothing DBMS specific in it:
> https://github.com/geotools/geotools/blob/master/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStoreFactory.java#L428
>
> Subclasses are allowed to override those methods, but the Oracle one does
> not (not sure if any subclass does at all):
> https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-oracle/src/main/java/org/geotools/data/oracle/OracleNGDataStoreFactory.java
>
thank you a lot for directions.
If I understood it the default value is set in OracleNGDataStoreFactory.java:
if (dataStore.getFetchSize() <= 0) {
// Oracle is dead slow with the fetch size at 0, let's
have a sane default
dataStore.setFetchSize(200);
}
Isn't it?
Looking on the web I see that a lot of people suggest that higher
values lead to slower performances, that to me is counter-intuitive.
In your experience it is spatial data that performs differently from
other data types or also with them it is better to set lower value of
the prefetch parameter?
Cheers,
Stefano
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
