Re: [cx-oracle-users] Python 2: unicode vs str param causing slowness

[Dayton G. <Day...@sy...>]

I grabbed the ful query, plus the bound variables. I get this for bound vars:

DATATYPE_STRING   VALUE_STRING
---------------------------    ----------------------
NVARCHAR2(32)        ios

It seems right. The only thing I notice is that the table definition is for NVARCHAR2(20).

From: Vladimir Ryabtsev <gre...@gm...<mailto:gre...@gm...>>
Reply-To: "cx-...@li...<mailto:cx-...@li...>" <cx-...@li...<mailto:cx-...@li...>>
Date: Tuesday, January 20, 2015 2:42 PM
To: "cx-...@li...<mailto:cx-...@li...>" <cx-...@li...<mailto:cx-...@li...>>
Subject: Re: [cx-oracle-users] Python 2: unicode vs str param causing slowness

Hi,
Did you try to look the text of actual query that being executed when you come across the slowness?
Something like this: http://stackoverflow.com/questions/55899/how-to-see-the-actual-oracle-sql-statement-that-is-being-executed
You can also find out the datatype of your bound variable :platform as mentioned here: http://stackoverflow.com/questions/1707291/how-to-get-the-last-executed-sql-statement-and-bind-variable-values-in-oracle
This will you give a clue about implicit datatype conversion.
I don't think it's a django thing.