Re: [cx-oracle-users] cursor.arraysize

[Anthony T. <an...@co...>]

The reason for the default being 1 is the DB API states that it ought to 
be and its safest -- since the use of long and long raw columns can 
quickly blow your available memory away! The simplest way to override 
the default is to do the following:

class MyConnection(cx_Oracle.Connection):

    def cursor(self):
        cursor = super(MyConnection, self).cursor()
        cursor.arraysize = 1000
        return cursor

Hope that helps.

Orr, Steve wrote:

>cursor.arraysize defaults to 1 but we're getting a significant
>performance boost at a plateau of about 1000. Is there any particular
>reason we should not set this to 1000 all the time? Apart from
>subclassing or modifying Cursor.c, isn't there anyway to change the
>default internal to cx_Oracle? 
>
>Steve Orr
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by BEA Weblogic Workshop
>FREE Java Enterprise J2EE developer tools!
>Get your free copy of BEA WebLogic Workshop 8.1 today.
>http://ads.osdn.com/?ad_idG21&alloc_id040&op=click
>_______________________________________________
>cx-oracle-users mailing list
>cx-...@li...
>https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>  
>