|Date: ||Thu, 2 Jun 2005 10:13:26 -0400|
|Reply-To: ||John McPeek <McPeek.John@BLS.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||John McPeek <McPeek.John@BLS.GOV>|
|Subject: ||SAS V9 v. Sybase on Solaris|
If you are using v9 under Solaris (8 or 9), reading from and writing to
Sybase tables, I need to learn from you. We are testing that hookup, using
Open Client 12.5 per SAS's instructions, and find v9 unacceptably slow to
read in rows.
One of my users has a VERY simple DATA step (with Libname statement
complete with "connection = unique" option) with the simplest imaginable
Where clause. It is supposed to retrieve 8.5 million rows or so, and it
does. But in v8.2, it needs roughly 17 minutes to accomplish that. In
v9.1.3, it needs 2 Hours 17 minutes. Toss in the "connection = unique"
option on the Libname statement and the "NoThreads" system option, and the
v9 time goes down to a mere 38 minutes. SAS Tech Support seems to be
Has anyone run into any such thing?