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

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

Yea, I think you're right. There's some implicit type conversion.

Sadly, flipping the WHERE clause didn't change the outcome.
-- 


On 1/20/15 10:39 AM, "Doug Henderson" <djn...@gm...> wrote:

>On 20 January 2015 at 08:55, Dayton Gomez <Day...@sy...>
>wrote:
>>
>> 100 seconds:
>> cursor.execute('''SELECT COUNT(*) FROM "device" WHERE "PLATFORM" =
>> :platform''', {'platform': u'ios'})
>>
>> .1 seconds:
>> cursor.execute('''SELECT COUNT(*) FROM "device" WHERE "PLATFORM" =
>> :platform''', {'platform': 'ios'})
>
>This sounds similar to problems where the indexed column is implicitly
>type converted to match the bind variable's type.
>
>To test this, in 11g, if possible, rewrite the query as:
>
>cursor.execute('''SELECT COUNT(*) FROM "device" WHERE :platform =
>"PLATFORM"''', {'platform': u'ios'})
>
>Doug
>
>-- 
>Doug Henderson, Calgary, Alberta, Canada
>
>--------------------------------------------------------------------------
>----
>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