Skip site navigation (1) Skip section navigation (2)

Re: ODBC Driver extremly slow on winxp

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Ben Litchfield" <ben(at)csh(dot)rit(dot)edu>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC Driver extremly slow on winxp
Date: 2002-10-18 13:41:07
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128B05@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

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

Responses

pgsql-odbc by date

Next:From: Ben LitchfieldDate: 2002-10-18 14:32:33
Subject: Re: ODBC Driver extremly slow on winxp
Previous:From: Dave PageDate: 2002-10-18 12:32:56
Subject: Re: Unknown Connect Option (Set)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group