Date: Mon, 31 Jan 2011 15:56:32 -0500
Reply-To: Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Subject: Re: Poor I/O performance
In-Reply-To: <E6484AFA609C954BA6A094E4C6BF3C12254E2B6A84@EXCH14.GHCMASTER.GHC.ORG>
Content-Type: text/plain; charset="us-ascii"
try a proc copy and see if that is any faster
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Tolbert, William
Sent: Monday, January 31, 2011 3:49 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Poor I/O performance
Hi all -- I've got a Windows 7 virtual machine connected to a storage area network (commonly referred to as a SAN).
Reading a 6GB SAS dataset from the SAN takes about 8 minutes in SAS. That's pretty slow and I naturally assumed I had a bandwidth issue. However, I can *copy* the file using Windows Explorer in 1 minute, consistently. This appears to be something peculiar to SAS. I'm experimenting with bufsize and bufno, but so far I haven't found anything to explain this much difference.
Here's some code:
Data work.myfile;
set san.myfile;
Run;
/* 8 minutes */
Copy \path\to\san\myfile myfile
/* 1 minute */
Thanks for you insight!
Bill
________________________________
GHC Confidentiality Statement
This message and any attached files might contain confidential information protected by federal and state law. The information is intended only for the use of the individual(s) or entities originally named as addressees. The improper disclosure of such information may be subject to civil or criminal penalties. If this message reached you in error, please contact the sender and destroy this message. Disclosing, copying, forwarding, or distributing the information by unauthorized individuals or entities is strictly prohibited by law.