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.

Reply via email to