Hi Massimo, thanks for the info! Please do you have more info about not converting to objects?
On Sunday, September 2, 2018 at 10:51:21 PM UTC+2, Massimo Di Pierro wrote: > > 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.