Paul Muharsky-474732 (5/20/2010)
I disagree that all your SQL should be optimized to 1 million+ records.
Heh... Yeah... I know I'm responding to an old post but the kind of attitude above why there are so many posts on this site that start with "I have this performance problem. Can anyone help"? If you look back at Peso's code, 4 milli-seconds vs almost 6 seconds isn't something that anyone in their right mind would disagree with. 😉
Write high performance code as if your life depended on it because saying "That's not my job" may be a self-fulfilling prophecy. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.