Re: Prepared Statements: Inefficient Type Conversion?

Kris Jurka wrote:
>> It seems that using the prepared statement to pass the value as a
>> string causes all of the 40 million upid values in the table to
>> convert to string, rather than the string parameter being converted
>> to a number. Can't the driver be smarter than that?
>
>
> You can try adding the url parameter stringtype=unspecified which will
> pass the String parameter untyped instead of as a String.
FWIW, that didn't seem to make a difference - actually, it takes even
longer to execute.

Thanks anyway. We'll try to get the datatype of the column changed.