> -----Original Message----- > From: CMSTSO Pipelines Discussion List [mailto:CMS- > [email protected]] On Behalf Of Rob van der Heij > Sent: 18 August 2011 13:32 > To: [email protected] > Subject: Re: [CMS-PIPELINES] Datatype selection question. > > On Thu, Aug 18, 2011 at 2:02 PM, Paul Lautman <[email protected]> > wrote: > > Is that likely to be more efficient than the lookup? Or is it only so > because the reference set is so small? > > According to RITA (on my reference system) > > rita < osmacro maclib | pick 73.3 == /RMH/ , /CGA/, /IBM/ | count lines > | cons > > 2918.950 ( 2918.950) ms total in "NoName001" (1 invocation) > > rita (end \) < osmacro maclib | l: lookup 73.3 1.3 | count lines | cons > \ lite > > 3307.113 ( 3307.113) ms total in "NoName001" (1 invocation) > > Guess it's worth to change my habits... > > | Rob But if the reference table was 3000 rather than 30 values would pick still be faster?
Aviva is the trading name for the principal subsidiaries of the Aviva Group in the United Kingdom. The principal subsidiaries are: Aviva Insurance UK Limited. Registered Office 8 Surrey Street, Norwich, Norfolk NR1 3NG. Registered in England Number 99122. Authorised and regulated by the Financial Services Authority. Aviva Life Services UK Limited. Registered Office 2 Rougier Street, York YO90 1UU. Registered in England Number 2403746. Authorised and regulated by the Financial Services Authority. Aviva Health UK Limited. Registered Office 8 Surrey Street, Norwich, Norfolk NR1 3NG. Registered in England Number 2464270. Authorised and regulated by the Financial Services Authority. ********************************************************************** This email and any files sent with it are intended only for the named recipient. If you are not the named recipient please telephone/email the sender immediately. You should not disclose the content or take/retain/distribute any copies. **********************************************************************
