Re: ODBC Driver extremly slow on winxp

From: Ben Litchfield <ben(at)csh(dot)rit(dot)edu>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC Driver extremly slow on winxp
Date: 2002-10-18 14:32:33
Message-ID: Pine.SOL.4.31.0210181030510.11291-100000@fury.csh.rit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


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(at)csh(dot)rit(dot)edu]
> > Sent: 12 October 2002 17:23
> > To: pgsql-odbc(at)postgresql(dot)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.
>

--

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ben Litchfield 2002-10-18 14:43:33 Characters inserted into select statement
Previous Message Dave Page 2002-10-18 13:41:07 Re: ODBC Driver extremly slow on winxp