Date: Wed, 12 Jul 2000 19:59:20 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: Re: INSERT SASDATASETS into ORACLE Tables
In article <firstname.lastname@example.org>,
> Welcome to the wonderful world of the stellar Oracle performance! I
> is worth those M$$ that migrated to the Oracle coffers. On a
> note, please let me suggest that you should read the excellent SUGI
> by our fellow sasler Dianne Rhodes "Migrate to ORACLE? I need my SAS
> Software!"? Suffices it to say that its conclusion consists of but a
> sentence: "Stick with SAS".
> Kind regards,
> Paul M. Dorfman
> Jacksonville, Fl
Perhaps you know something about John's situation that I don't so my
comments should be read with that in mind. I will say I agree that
migration to Oracle is very expensive and, in many cases where the
business already uses SAS, unnecessary.
As far as proc dbload-ing data into Oracle goes, I have found that
dbload is rather inefficient as compared to, say, SQL*Loader which
should be able to handle loading 10,000,000 records in MUCH less time
than 24 hours. However, when pulling data out of Oracle, I have found
just the opposite -- SAS compares very well to and in some cases
performs better than other solutions such as "spooling", the PL/SQL
utl_file package, and Pro C.
Also, I am curious. Do you find that SAS can deal with very large
amounts of data as well as Oracle can? (I have no specific number in
mind when I say "large".) I have always been under the (admittedly
vague) impression that, for sheer speed in storing/processing very
large amounts of data, Oracle is superior. I realize that this all
depends on how the data is organized, indexed, etc.
Understand that I am asking these questions as a longtime user and
proponent of SAS. I am simply curious about your experience.
Sent via Deja.com http://www.deja.com/
Before you buy.