Date: Mon, 28 Oct 2002 07:44:06 -0600
Reply-To: Kevin Myers <KevinMyers@AUSTIN.RR.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Kevin Myers <KevinMyers@AUSTIN.RR.COM>
Subject: Re: How to upload 140 millions of record from SAS To SQL server
Content-Type: text/plain; charset="iso-8859-1"
I don't know enough about loading data into SQL Server to help with that.
On the SAS side, I assume that you are using ViewTable in V8.x to open the
table? ViewTable is the default data browser that you get if you just
double click on a table to view the contents.
Unfortunately ViewTable is not the most efficiently written SAS application,
and scrolling text in Windows is not something that SAS does extremely well.
However, there are several easy techniques that you can use which may help a
lot. For example, what method are you using to "scroll down" to reach the
end of the table? Don't click on one of the scroll bar arrows or use the
cursor keys or page down. All of those methods are extremely slow. Just
grab the scroll bar handle and drag it instead. I think that will give you
the performance that you are looking for. Using the BOTTOM command in the
SAS command bar will get you there even faster. Hope these suggestions
might be of help.
----- Original Message -----
From: "Subramani, Kavitha (CAP, ACOE)" <email@example.com>
To: "'Kevin Myers'" <KevinMyers@austin.rr.com>
Sent: Monday, October 28, 2002 2:59 AM
Subject: RE: How to upload 140 millions of record from SAS To SQL server
> Thanks for your reply.
> Actually i tried to open 1 million of record in sas. When i scroll down
> it is taking more than 5 minutes to come to the end. But in SQL
> pc) it is very fast.
> That is why i said like that. Becoz i'm new to sas i donno more about it.
> you are saying must be true.
> Now what i want is i would like to upload more than 100 millions of record
> from SAS dataset into one single
> table in SQL Server. After that i want to use this data for analying. U r
> correct... :-)
> -----Original Message-----
> From: Kevin Myers [mailto:KevinMyers@austin.rr.com]
> Sent: Monday, October 28, 2002 1:53 PM
> To: kavitha
> Subject: Re: How to upload 140 millions of record from SAS To SQL server
> Performance not good in SAS??? Sounds to me like performance isn't good
> SQL Server!!!
> Seriously though, performance all depends on the application and the
> of your data structure, whether in SAS, SQL Server, or anything else.
> Depending on the specific application, SAS may be able to beat the pants
> SQL Server. Then again, there are definitely some scenarios (mostly
> transaction processing oriented) where SQL Server could blow SAS away.
> exactly is it that you are trying to do with the data? It sounds like you
> are probably trying to analyze it, and in many scenarios SAS will be
> significantly faster at that than SQL Server, if utilized properly...
> ----- Original Message -----
> From: "kavitha" <kavitha.subramani@GEIND.GE.COM>
> Newsgroups: bit.listserv.sas-l
> To: <SAS-L@LISTSERV.UGA.EDU>
> Sent: Monday, October 28, 2002 1:14 AM
> Subject: How to upload 140 millions of record from SAS To SQL server
> > Hi
> > I have converted 140 millions of record from flat text files into SAS
> > data set using SAS Program. As the performance is not good in SAS i
> > would like to upload these SAS data directly into single table in SQL
> > Server. And i want to know how many hours will it take to upload.
> > Actually im trying this uploading thro DTS concept in SQL server. It
> > is taking 1hour to upload around 4millions of record.
> > Please let me knw how to do this efficiently.
> > Waiting for your reply.
> > Thanks in advance
> > Kavitha