Date:         Fri, 7 Sep 2007 14:47:16 -0400
Reply-To:     "Yu, Hsiwei" <hsiwei.yu@SPCORP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Yu, Hsiwei" <hsiwei.yu@SPCORP.COM>
Subject:      SASHELP.vtable access slow IF i have libname pointing to Oracle?
In-Reply-To:  <200709071250.l87CTa3S019327@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Hello, curious if u have noticed or not.
 
i'm on Windows, SAS 9.1.3, and have some libraries pointing to Oracle,
below code runs for about 1 minute real time, with these msg in SAS log
data _null_;

set sashelp.vtable;

where libname = 'a_SAS_libref' and memname not in ( ... );

put memname=;

run;

 
NOTE: Due to the PRESERVE_TAB_NAMES=NO libname option setting, 4
table(s) have not been

displayed/returned.

NOTE: Due to the PRESERVE_TAB_NAMES=NO libname option setting, 57
table(s) have not been

displayed/returned.

 
 
i then removed those libnames pointing to Oracle & re-run then it took
about 8 seconds and w/o those msg.
 
If u also noticed this run time difference, the next question is how to
improve? Thanks, Happy Weekend,
 

Hsiwei Yu 
908-473-7157 (Work) 
908-473-5660 (Work Fax) 
718-908-7681 (Cell) 

S9-105Q 
Mail Stop S9-1-1700 
Summit, NJ 07901 

 

*********************************************************************
This message and any attachments are solely for the
intended recipient. If you are not the intended recipient,
disclosure, copying, use or distribution of the information 
included in this message is prohibited -- Please 
immediately and permanently delete.