Date:         Tue, 13 Oct 1998 12:34:45 +0200
Reply-To:     erik.rasmussen@leo.dk
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Erik M Rasmussen <erik.rasmussen@LEO.DK>
Organization: LEO Pharmaceutical Products
Subject:      MS Access95 -> SAS via ODBC - very slow!

Hi there
 
I have a MS Access 95 (ver. 7.0) application
and want to export data tables to SAS datasets
using ODBC.
 
As such this works fine, but some tables
are extremely slowly transferred from
Access to SAS. One such 'slow' table is
a table containg only 4 text variables with
lengths of 50, 200, 5 and 54 characters
and a total of approx. 41.000 records. After
10 minutes time, approx. 5.000 records had
been transferred to SAS (ODBC logging is 'off',
when log is 'on' it goes even slower). Obviously,
I had to stop the job.
 
My hardware is a Compaq Deskpro with
a 300 MHz Pentium-II and 64 megs. of RAM.
(And it does not work much faster on
a PII-350 with 128 megs. of RAM).
 
SAS is ver 6.12 TS045 for Windows
 
Win95 is the OSR 2.1 version.
 
In the setup of the ODBC connection, I noticed
the possibility of adding options in the
'specifying SQL options' part. It is stated, that
this should be done only as directed by
SAS Institute Tech. Supp. Staff.
 
Do you know of any options which may speed
up the ODBC-based datatransferral process?
 
Or perhaps any editing of the Win95 registry?
 
Kindly note, that I do not have the SAS ACCESS
module. I do have the latest SAS ODBC 32-bit
drivers (as found on SAS' FTP site)
 
Kind Regards and TIA
Erik M Rasmussen, M.Sc.
Leo Pharmaceutical Products