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

[Richard M. <ri...@we...>]

Chris Dunscombe wrote:
> Now if I need to do the test on None then I believe I need to call a
> function or have the if test inline in a loop and with many columns
> this is quite an overhead. In my test case on a 13 column table
> returning 200K rows:

If your application is that performance critical then you might
want to benchmark a few different implementations. eg. using an
array instead of an if with something like:

newowner    = [self.newowner, None][self.contactid == self.newowner]

This is taken from one of my apps, you'll obviously need to
modify if for yours.

Rich.
-- 
Richard Moore, Principal Software Engineer,
Westpoint Ltd,
Albion Wharf, 19 Albion Street, Manchester, M1 5LN, England
Tel: +44 161 237 1028
Fax: +44 161 237 1031