It's something I've always done over the last twenty years. The select processor in theory should apply optimisiation but I always break my statements down to reduce the working record set and to increase readability.
Makes very little difference on smaller amount of records but makes a huge difference when record counts get into the millions, especially on distributed files or selects which work on a mixture of non-indexed and indexed fields. ________________________________ From: [EMAIL PROTECTED] on behalf of Mark Johnson Sent: Thu 11/11/2004 13:58 To: [EMAIL PROTECTED] Subject: Re: [U2] PICK Assembler Language In all of my travels of code before me at my clients, I have never seen a convoluted SELECT statement broken up into 2 or more pieces for effeciency reasons. I stumbled on the idea around 9 years ago trying to squeeze a few more drops of speed from a 386-based system running InfoQuest. I saw the 95% wasted translates based on my original example and got a 50% increase in speed running a process that had to run about 15 times per user per day. Almost won the Nobel Prize with that client. Not that I've seen everything or more than all, but in my 25+ years of pick covering about 40 different platforms and environments I have never seen a SELECT statement broken up. Thanks. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 11, 2004 6:13 AM Subject: Re: [U2] PICK Assembler Language > Just because we have a quadrillion microseconds to play with, instead of a > 50 millisecond timeslice, doesn't mean we have to waste them. A few moments to > consider performance, done once in the development cycle, will pay benefits > every time a more efficient program is run. I have to believe that Adm Grace > Hopper is smiling down on you both. > > Regards, > Charlie Noah > > [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: > > -----Original Message----- > <snip> > > I can't imagine anyone on this forum having to break up this sentence > likewise on the current platforms. On this client's older MCD, it truly > makes a difference. > > </snip> > ------------------------- > > Ah, Mark......I do this all the time for the performance reasons mentioned > :) > > Rich Taylor | Senior Programmer/Analyst| VERTIS > 250 W. Pratt Street | Baltimore, MD 21201 > P 410.361.8688 | F 410.528.0319 > [EMAIL PROTECTED] | http://www.vertisinc.com > > Vertis is the premier provider of targeted advertising, media, and > marketing services that drive consumers to marketers more effectively. > > "The more they complicate the plumbing > the easier it is to stop up the drain" > > - Montgomery Scott NCC-1701 > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
