Postgres Pro
Downloads
Home   >   mailing lists

Thread: ODBC Driver extremly slow on winxp

ODBC Driver extremly slow on winxp

From
Ben Litchfield
Date:
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.

When I run the command line psql program it is very fast.  When I use the
JDBC driver it is very fast.

Any help would be great.
--

Re: ODBC Driver extremly slow on winxp

From
"Dave Page"
Date:

> -----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.

Re: ODBC Driver extremly slow on winxp

From
Ben Litchfield
Date:
Thank you very much, that seemed to fix the problem.

Ben Litchfield



On Fri, 18 Oct 2002, Dave Page wrote:

>
>
> > -----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.
>

--