Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Re: odbc batching
From
Argyn Kuketayev <[email protected]>
To
[email protected]
Subject
Re: st: Re: odbc batching
Date
Fri, 11 Mar 2011 11:01:46 -0500
Hello
On Fri, Mar 11, 2011 at 10:50 AM, Dimitriy V. Masterov
<[email protected]> wrote:
> I download data of this size from MS SQL server on 64-bit Windows
> machine on a regular basis. It is not fast, but it is certainly faster
> than getting a text file through SQL Server Mangement Studio and
> reading that text file into Stata. The text file approach is also
> manual.
I also use MS SQL Server on 64 bit Windows. Our hard drive is not fast
though. I wouldn't create a text file with Studio. I'd run a script to
dump into a file directly, then read it in Stata.
Do you have any performance metrics? How fast does it load odbc on your machine?
cheers
--
Argyn Kuketayev
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/