See https://groups.google.com/d/msg/web2py/1ULZttF2a-k/r5ZeDbTfAAAJ.
You can start by setting cacheable=True to see if that helps, and then try the custom processor if it's still too slow. Anthony On Monday, November 19, 2018 at 7:53:25 AM UTC-5, Thomas Klopf wrote: > > 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.