Re: [cx-oracle-users] Modifying fetched data python types for zope adaptor

[Amaury F. d'A. <ama...@gm...>]

Hello,

Andy Hird wrote:
> One thought I had after getting some sleep is that passing in the types
> cx_Oracle normally returns means you end up constructing the returned object
> twice anyway and you lose some of the performance benefits of doing this.
> I'm not sure whether building a string to pass into settype is much less
> work or not.

Yes, this is inherent to any method derivation : you have one more
function to call, one more list of arguments to pass, new values to
build... In python IIRC, the first two are the most significant for
performance.
At least you don't have to keep the two lists of rows in memory.

For advanced users, we should provide way to derive their own types in
C code. The Variable object would have access to the raw OCI buffer,
to be as fast as the original type.

-- 
Amaury Forgeot d'Arc