Date: Wed, 28 May 1997 22:20:59 -0400
Reply-To: Eric Weiss <eweiss@WINCHENDON.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Eric Weiss <eweiss@WINCHENDON.COM>
Organization: The Winchendon Group, Inc.
Subject: Re: SQL: When shouldn't you use it?
I like SQL when the retieval involves only minimal calculations. I
benchmarked PROC SQL on a Sun IPX and found that it slowed down greately
when I did multiplication or division. Even addition and subtraction
make a noticeable difference in speed. It seems to be most useful when
there are several merges/joins that do not require a lot of parentheses
to make work.