[cx-oracle-users] AW: cx-oracle-users digest, Vol 1 #99 - 8 msgs

[Henning v. B. <H.v...@t-...>]

Chris,

why do you think the simple statement "if x is None: x=3D''" means an
overhead?
It means about 0.000(insert zeroes here)1 percent performance overhead,
because transferring/outputting the data is what takes most of time.

And - with Python - it should not mean too much typing overhead.
You could easily write a function to do this automatically for each
record.

HTH
Henning


> -----Urspr=FCngliche Nachricht-----
> From: Chris Dunscombe <cdu...@ya...>
> To: cx-oracle-list <cx-...@li...>
> Subject: [cx-oracle-users] Nulls returned as None and not as=20
> as "empty or zero lenght string"
> Reply-To: cx-...@li...
>=20
> All,
>=20
> Is there anyway that Null values returned from a query can be=20
> an "empty or zero length string"
> instead of None?
>=20
> This may seem a strange request as it's easy to use type to=20
> test if a null has been returned as
> None. However I've a performance critical app where I need to=20
> output "nothing" (zero length /
> empty string) if the value is null. Hence at present I have=20
> to perform this "type test" on ALL
> columns that don't have a "Not Null" constraint in the=20
> database which is quite an overhead when in
> some cases I need to do it millions and sometimes billions of times.
>=20
> Thanks,
>=20
> Chris Dunscombe
>=20