LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2000, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 21 Sep 2000 10:17:15 -0400
Reply-To:   thp3@DAIMLERCHRYSLER.COM
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Tom Pruitt <thp3@DAIMLERCHRYSLER.COM>
Subject:   TERRIBLE SQL PERFORMANCE v8 vs. v6 (query included this time)
Content-type:   text/plain; charset=us-ascii

Anyone had any problems with proc sql queries under v8.0??

The following simple query takes 9 seconds under v6 and 10 MINUTES under v8!!

proc sql _METHOD; create table buildbin as select distinct c_line, i_prob, bandtext, bandnum, count(distinct i_vhcl_v) as buildbin from rear2 group by c_line, i_prob, bandtext; quit;

Any theories??

Tom


Back to: Top of message | Previous page | Main SAS-L page