Date:         Wed, 12 Jul 2000 19:59:20 GMT
Reply-To:     joe17836@MY-DEJA.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         joe17836@MY-DEJA.COM
Organization: Deja.com - Before you buy.
Subject:      Re: INSERT SASDATASETS into ORACLE Tables

In article <20000712175106.47124.qmail@hotmail.com>,
  sashole@mediaone.net wrote:
> John,
>
> Welcome to the wonderful world of the stellar Oracle performance! I
hope it
> is worth those M$$ that migrated to the Oracle coffers. On a
constructive
> note, please let me suggest that you should read the excellent SUGI
25 paper
> 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
single
> sentence: "Stick with SAS".
>
> Kind regards,
> ====================
> Paul M. Dorfman
> Jacksonville, Fl
> ====================
>

Paul,

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.

Thank you.



Sent via Deja.com http://www.deja.com/
Before you buy.