[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