[cx-oracle-users] cx-oracle performance with django and NCLOB data type

[Daniel P. <dan...@gm...>]

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