Re: Python 2: unicode vs str param causing slowness
Dayton Gomez <Dayton_Gomez-okLH5SSHHyRWk0Htik3J/[email protected]> Wed, 21 Jan 2015 10:37:22 -0800
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <D0E53FD6.3945E%[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:[email protected]>" <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-5NWGOfrQmneHXe+LvDLADg@public.gmane.orgrceforge.net>" <cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org<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 cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users