Date: Mon, 28 Oct 2002 11:38:41 -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
table(single)
Content-Type: text/plain; charset="iso-8859-1"
Hmmm, as Peter Crawford just pointed out to me, both the BOTTOM command and
dragging the scroll bar handle are still very disapppointingly slow with
large tables in SAS 8.2 ViewTable. However, I could have sworn that this
problem had been fixed? Maybe it is corrected in 9.0/9.1??? I'll see if
any little birdies know. Meanwhile, I stand corrected, and please forgive
the misinformation...
s/KAM
----- Original Message -----
From: "Kevin Myers" <KevinMyers@austin.rr.com>
To: "Subramani, Kavitha (CAP, ACOE)" <kavitha.subramani@geind.ge.com>
Cc: "SAS Users" <sas-l@listserv.uga.edu>
Sent: Monday, October 28, 2002 7:44 AM
Subject: Re: How to upload 140 millions of record from SAS To SQL server
table(single)
> 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.
>
> s/KAM
>
>
> ----- Original Message -----
> From: "Subramani, Kavitha (CAP, ACOE)" <kavitha.subramani@geind.ge.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
> table(single)
>
>
> > 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
> server(same
> > pc) it is very fast.
> > That is why i said like that. Becoz i'm new to sas i donno more about
it.
> So
> > whatever
> > 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... :-)
> >
> > Kavitha
> >
> >
> >
> >
> >
> > -----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
> > table(single)
> >
> >
> > Performance not good in SAS??? Sounds to me like performance isn't good
> in
> > SQL Server!!!
> >
> > Seriously though, performance all depends on the application and the
> design
> > 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
> off
> > SQL Server. Then again, there are definitely some scenarios (mostly
> > transaction processing oriented) where SQL Server could blow SAS away.
> What
> > 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...
> >
> > s/KAM
> >
> >
> > ----- 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
> > table(single)
> >
> >
> > > 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
>
| 
