[opencms-dev] Oracle change default jdbc fetch size

Mario Jäger m.jaeger at alkacon.com
Tue Jun 15 09:45:24 CEST 2010


Hi Mirko,

In my last mail I sent you a link where is shown how to set the Oracle prefetch value using the method |setDefaultRowPrefetch()|. 
Equivalently, instead of calling |setDefaultRowPrefetch()|, you can set the |defaultRowPrefetch| Java property if you use a Java |
Properties| object in establishing the connection: 
http://www.di.unipi.it/~ghelli/didattica/bdldoc/A97329_03/web.902/a90211/basic.htm#1006248

-- 
Kind Regards,
Mario.
 
-------------------
Mario Jäger
 
Alkacon Software GmbH  - The OpenCms Experts                    
http://www.alkacon.com - http://www.opencms.org


Mirko Ravot schrieb:
>
> Hi all,
>
>  
>
> We have performance issues with opencms+oracle database.
>
> Does any know how to change fetch size from oracle default jdbc (10) 
> to higher?
>
>  
>
> Regards,
>
>  
>
> Mirko
>
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev



More information about the opencms-dev mailing list