Re: st: ODBC Performance

[Kevin Crow <kcrow@stata.com>]

Currently the only way to improve the speed of reading and writing data 
to a database is to use Stata plugins instead of ODBC to read and write 
your data.  Point your web browser to the URL below to read an FAQ on 
our web site about using plugins to connect to databases.

http://www.stata.com/support/faqs/data/plugin_database.html

Kevin
StataCorp




Sebastian F. B�chte wrote:

> Dear all,
>
> lately I have been thinking about using a database server/engine for
> storing all the data I am working with in Stata. I thought about using
> PostgreSQL in combination with the ODBC commands that are offered
> Stata. However, eventhough PostgreSQL is fast and my computing
> hardware is somewhat of uptodate I am experiencing a very poor
> perfomance when using ODBC commands to read data into Stata or to
> store data in a database from within Stata.
>
> I am now hoping that maybe some of you have ideas on how to improove
> the perfomance.
>
> Regards
> Sebastian
> *
> *   For searches and help try:
> *   http://www.stata.com/support/faqs/res/findit.html
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/