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 (August 2005, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 11 Aug 2005 09:50:20 -0600
Reply-To:   nyiann <nwy@UALBERTA.CA>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   nyiann <nwy@UALBERTA.CA>
Organization:   The University of Alberta
Subject:   Re: small slices of big data sets
Comments:   To: sas-l@uga.edu
In-Reply-To:   <200508101636.j7AGauPE031478@listserv.cc.uga.edu>
Content-Type:   TEXT/PLAIN; charset=US-ASCII; format=flowed

Success!

By passing the query to DB2 directly--optimized as Paul Dorfman suggested--the extraction process is much, much faster, and proportional to the number of records being queried. A one month extract takes 2 minutes!

Thanks again! N

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu