Hi everyone, Not sure if my last post made it through or not... Please does anyone know a good way to set the 'arraysize' value on the cx_Oracle cursor through web2py? I'm having performance issues with web2py connecting to a remote Oracle DB. I manually connected with cx_Oracle and setting this value dramatically improved the performance. I tried sifting through web2py code but realized it might be better to ask how to do that here :)
example with cx_Oracle: db=cx_Oracle.connect(...) cursor=db.cursor() cursor.arraysize=100000 cursor.execute(sql) Thanks! Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
