Re: [cx-oracle-users] : CLOB performance issue

[Vladimir R. <gre...@gm...>]

2014-07-14 16:35 GMT+04:00 avinash nandakumar <avi...@or...
>:

> It looks like in the current code the variable.setvalue() function for
> LOBs uses OCILobTemporary() which is a call to the server.
> 100 MB would be transferred to the server during this call.  Hence the
> call appears to take more time at the time of filling.
> Subsequent execute() will just be adjusting the descriptors in the table
> in the db.
> End to end there should not be any additional processing.
>
> Best Regards,
> Avinash
>

Hello Avinash,

is it really necessary to call OCILobTemporary() in OCI level? Do you
consider implementation of cx_Oracle correct?

If I write my code in Java (for example) it works much faster, that's why I
suppose the problem is in cx_Oracle. I see the difference in performance
only in case I work CLOBs, performance is comparable if I use simple data
types.