You can with
db = DAL('oracle:...)
db.connection.cursor.arraysize =100000
But I suspect the problem is another. The problem is that web2py turns the
response into objects and that takes a lot of time.
If you do not want that there is a way to prevent it.
On Sunday, 2 September 2018 11:03:30 UTC-7, Thomas Klopf wrote:
>
> Hi everyone!
> Please I'd appreciate some tips on a problem I'm having.. I have a
> remote Oracle DB I'm connecting to with web2py, and performance is very
> slow retrieving large select queries/result sets. I tried manually
> connecting with the cx_Oracle package, and found a huge performance
> increase by setting the "arraysize" value really high, e.g.:
>
> db = cx_Oracle.connect("blablabla")
> cursor = db.cursor()
> cursor.arraysize =100000
> cursor.execute(somesql)
>
> but please how can I change this 'arraysize' value within web2py/DAL with
> the Oracle driver?
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
