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