Re: [cx-oracle-users] Python 2: unicode vs str param causing slowness
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] Python 2: unicode vs str param causing slowness
|
From: avinash n. <avi...@or...> - 2015-01-26 05:41:08
|
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 <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
>
>
>
>
> ------------------------------------------------------------------------------
> 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...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
|
