Re: Python 2: unicode vs str param causing slowness

Hello Dayton,

I have tried to reproduce the issue on cx-oracle with Oracle 11 with DB 
charset W8DEC and NCHAR charset AL16UTF16.
However I was not able to reproduce the problem.

Although some of these you have provided before in order to consolidate 
can you please give details for the following:-
1. Oracle version number
2. cx-oracle version
3. DB characterset
4. DB Ncharset
5. NLS_LANG
6. Table schema
7. Table data

Best Regards,
Avinash

On 1/22/2015 7:34 PM, Dayton Gomez wrote:
> 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 <shai-9mtU2oJkgntWk0Htik3J/[email protected] <mailto:shai-9mtU2oJkgntWk0Htik3J/[email protected]>>
> Reply-To: "cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>" 
> <cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>>
> Date: Thursday, January 22, 2015 4:03 AM
> To: "cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>" 
> <cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>>
> 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 
> <[email protected] <mailto:[email protected]>> 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 <Dayton_Gomez-okLH5SSHHyRWk0Htik3J/[email protected]
>     <mailto:Dayton_Gomez-okLH5SSHHyRWk0Htik3J/[email protected]>>:
>
>         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 <[email protected]
>         <mailto:[email protected]>>
>         Reply-To: "cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>         <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>"
>         <cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>         <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>>
>         Date: Tuesday, January 20, 2015 2:42 PM
>         To: "cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>         <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>"
>         <cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>         <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>>
>         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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>         <mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
>         https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>
>
> ------------------------------------------------------------------------------
> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

------------------------------------------------------------------------------
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