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/