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

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

Correct. It's set to ".UTF8" on all our systems. I've tried random other encodings with no difference (was shooting in the dark).
From: Shai Berger <sh...@pl...<mailto:sh...@pl...>>
Reply-To: "cx-...@li...<mailto:cx-...@li...>" <cx-...@li...<mailto:cx-...@li...>>
Date: Thursday, January 22, 2015 4:03 AM
To: "cx-...@li...<mailto:cx-...@li...>" <cx-...@li...<mailto:cx-...@li...>>
Subject: Re: [cx-oracle-users] Python 2: unicode vs str param causing slowness

Django sets it to ".UTF8".

On 22 בינואר 2015 12:46:07 GMT+02:00, Vladimir Ryabtsev <gre...@gm...<mailto:gre...@gm...>> wrote:
Dayton,
what is the value of NLS_LANG on client machine?
What is returned by 'SELECT USERENV ('language') FROM DUAL' when calling from django?

2015-01-21 21:37 GMT+03:00 Dayton Gomez <Day...@sy...<mailto: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.


------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
cx-oracle-users mailing list
cx-...@li...<mailto:cx-...@li...>
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users