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

[Chris D. <cdu...@ya...>]

Rich,

Thanks for the idea, I'll give it a look.

Chris
--- Richard Moore <ri...@we...> wrote:
> 
> 
> 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
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/