Thread: Performance Tips

Eduardo Cadena

En Tue, 15 Oct 2002 14:51:46 -0500 (CDT)
Eduardo Cadena <ecadena@rocketmail.com> escribió:

> Does anyone can my tell me some tips to improve perfomance?
>
> My working platform is WinNT4 / Cygwin 1.3.10 / PostgreSQL 7.2.1

The first tip would be to use some Unix server.  Cygwin is known to be
slow.  Install some recent Linux distribution if you want to have it
easy - PostgreSQL comes bundled there.  Some people here like the *BSDs
best, but if you just want to test, I recommend you try Linux first.

The native port to WinNT will probably take some months before it's
ready for public consumption -- it's presently in beta testing.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Los romanticos son seres que mueren de deseos de vida"

On Tue, 15 Oct 2002, Eduardo Cadena wrote:

>
> Does anyone can my tell me some tips to improve perfomance?
>
> My working platform is WinNT4 / Cygwin 1.3.10 / PostgreSQL 7.2.1
>
> I successfully migrate an MS-Access DB to postgres, but it seems that Postgres version is working slowly .... I'm
usingODBC to connect both DB. 
>

Well, without seeing any queries, or knowing how big your tables are or
what your schemas are, there's not a lot we can do to help.  What can you
tell us about your data and schema?

If your application is using Data Access Objects(DAO) it'll be slow always.
If so, try migrating to ActiveX Data Objects (ADO) and you'll see a big
difference.

"Eduardo Cadena" <ecadena@rocketmail.com> wrote in message
news:20021015195146.3600.qmail@web14004.mail.yahoo.com...
> --0-1377194344-1034711506=:3525
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
>
> Does anyone can my tell me some tips to improve perfomance?
>
> My working platform is WinNT4 / Cygwin 1.3.10 / PostgreSQL 7.2.1
>
> I successfully migrate an MS-Access DB to postgres, but it seems that
Postgres version is working slowly .... I'm using ODBC to connect both DB.
>
> Thanks
>
> Eduardo Cadena
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Net: La mejor conexi�n a internet y 25MB extra a tu correo por $100
al mes.
>
> --0-1377194344-1034711506=:3525
> Content-Type: text/html; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
> <FONT face=Helv size=2>
> <P>Does anyone can my tell me some tips to improve perfomance?</P>
> <P>My working platform is WinNT4 / Cygwin 1.3.10 / PostgreSQL 7.2.1</P>
> <P>I successfully migrate an MS-Access DB to postgres, but it seems that
Postgres version is working slowly .... I'm using ODBC to connect both
DB.</P>
> <P>Thanks</P>
> <P>Eduardo Cadena</P></FONT><p><br><hr size=1><b>Do You Yahoo!?</b><br>
> <a href="http://net.yahoo.com.mx"><b>Yahoo! Net</b></a>: La mejor conexi�n
a internet y 25MB extra a tu correo por
> <a href="http://net.yahoo.com.mx/">$100 al mes</a>.<br>
> --0-1377194344-1034711506=:3525--

If your application is using Data Access Objects(DAO) it'll be slow always.
If so, try migrating to ActiveX Data Objects (ADO) and you'll see a big
difference.
"Eduardo Cadena" <ecadena@rocketmail.com> wrote in message
news:20021015195146.3600.qmail@web14004.mail.yahoo.com...
> --0-1377194344-1034711506=:3525
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
>
> Does anyone can my tell me some tips to improve perfomance?
>
> My working platform is WinNT4 / Cygwin 1.3.10 / PostgreSQL 7.2.1
>
> I successfully migrate an MS-Access DB to postgres, but it seems that
Postgres version is working slowly .... I'm using ODBC to connect both DB.
>
> Thanks
>
> Eduardo Cadena
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Net: La mejor conexi�n a internet y 25MB extra a tu correo por $100
al mes.
>
> --0-1377194344-1034711506=:3525
> Content-Type: text/html; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
> <FONT face=Helv size=2>
> <P>Does anyone can my tell me some tips to improve perfomance?</P>
> <P>My working platform is WinNT4 / Cygwin 1.3.10 / PostgreSQL 7.2.1</P>
> <P>I successfully migrate an MS-Access DB to postgres, but it seems that
Postgres version is working slowly .... I'm using ODBC to connect both
DB.</P>
> <P>Thanks</P>
> <P>Eduardo Cadena</P></FONT><p><br><hr size=1><b>Do You Yahoo!?</b><br>
> <a href="http://net.yahoo.com.mx"><b>Yahoo! Net</b></a>: La mejor conexi�n
a internet y 25MB extra a tu correo por
> <a href="http://net.yahoo.com.mx/">$100 al mes</a>.<br>
> --0-1377194344-1034711506=:3525--