cx-oracle performance with django and NCLOB data type

Hi there,

I'm not exactly sure if this is the right place but - I'm having a
performance problem with django running against an oracle database using
cx-oracle. It's django 1.4 and cx-oracle 5.1.3 using the oracle 11g client.
I did, however, upgrade to python 3, django 1.7.7 and cx-oracle 5.1.3 and
successfully reproduce the problem.

The queries don't seem to be the problem. The queries complete pretty
quickly. The problem seems to be taking the query results and instantiating
objects (through django's ORM). All of the results are slow, but the
egregious ones are ones that return NCLOB. It takes ~21 seconds to return
6k records as django models (just grabbing everything: essentially SELECT *
FROM ...). If you exclude the NCLOB columns, it reduces to a (still kind of
unreasonable) 1.5 seconds.

Are there known issues here? Does anyone have any advice for running
this/them down? Are there workarounds? I don't know what next steps to take.

Thanks for your help!
Daniel

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users