Re: ODBC Driver extremly slow on winxp

> -----Original Message-----
> From: Ben Litchfield [mailto:ben@csh.rit.edu]
> Sent: 12 October 2002 17:23
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC Driver extremly slow on winxp
>
>
>
> Here is my configuration
>
> ODBC Driver version 07_02_0003
> Postgresql: 7.2.2
> OS:WinXP with all latest patches
>
>
> The problem occurs when I connect to the database from the
> machine that the database is hosted on.  I will do something
> that will query the database and it will take about 1-2
> minutes to finish, I also notice that my harddrive is
> grinding the entire time.  I am not sure what it is doing.
> When I do the same thing from another machine it is very fast
> as one would expect.
>
> I have tried using two applications pgAdminII and a C#
> application both have the same results.

In the ODBC driver manager in control panel, make sure that SQL tracing
is turned off.

Regards, Dave.