Re: Very slow executes with utf8 integer parameters in DBD::Oracle

2007-09-17 Thread Peter J. Holzer
On 2007-09-14 18:03:15 +0100, Martin Evans wrote: I have NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as recommended in DBD::Oracle when using utf8 and I need to as my data is utf8 in Perl. Grossly simplified my code does: o select integer_primary_key_field from table o prepare(select from

Re: Very slow executes with utf8 integer parameters in DBD::Oracle

2007-09-17 Thread Martin Evans
Peter J. Holzer wrote: On 2007-09-14 18:03:15 +0100, Martin Evans wrote: I have NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as recommended in DBD::Oracle when using utf8 and I need to as my data is utf8 in Perl. Grossly simplified my code does: o select integer_primary_key_field from table o

Very slow executes with utf8 integer parameters in DBD::Oracle

2007-09-14 Thread Martin Evans
I have NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as recommended in DBD::Oracle when using utf8 and I need to as my data is utf8 in Perl. Grossly simplified my code does: o select integer_primary_key_field from table o prepare(select from another_table where field = ?) o