Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: ODBC Performance


From   "Sebastian F. Büchte" <sfbuechte@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: ODBC Performance
Date   Mon, 26 Feb 2007 22:10:34 +0100

Thank you for your advice.

Sebastian

On 2/23/07, Kevin Crow <kcrow@stata.com> wrote:
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/

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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index