Re: st: Re: odbc batching

["Dimitriy V. Masterov" <dvmaster@gmail.com>]

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.

However, I usually use odbc load as infrequently as possible. I
usually get the data once, compress, and then save it as a Stata file
and work with that. If this is a repetitive exercise, you can set
Stata to grab the data and save it earlier in the day, before you need
it.

Another useful option is to use -odbc exec("SqlStmt")-, where you
reduce the amount of data you have to grab with SqlStmt by reducing
the number of variables, observations, or using a date range.

I don't know of a way of getting Stata to show its progress.

DVM
*
*   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/