Re: Python 2: unicode vs str param causing slowness
Dayton Gomez <Dayton_Gomez-okLH5SSHHyRWk0Htik3J/[email protected]> Thu, 22 Jan 2015 06:04:24 -0800
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <D0E6513C.394FB%[email protected]> |
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 <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Thursday, January 22, 2015 4:03 AM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[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: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Tuesday, January 20, 2015 2:42 PM To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> 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