Re: : CLOB performance issue
Vladimir Ryabtsev <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAMqTPqnCsLxKBBtZDegyE_vJHfT33pM0RNoL8h3+Ceh2KTmC8g@mail.gmail.com> |
2014-07-14 16:35 GMT+04:00 avinash nandakumar <[email protected] >: > 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. ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users