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

Re: slow odbc access....

From: Tibor Laszlo <ltibor(at)mail(dot)tiszanet(dot)hu>
To: Sanjay Arora <sk(at)pobox(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: slow odbc access....
Date: 2000-11-29 11:01:04
Message-ID: 00112912044106.02030@tir (view raw or flat)
Thread:
Lists: pgsql-interfaces
> Another thing that is peculiar is that while the query is being executed
> that the HDD light on the WinNT client machine goes bonkers. It seems that
> the ODBC driver is caching something on the local hdd. I do have the odbc
> log on but the hdd activity seems to be too intensive for that. Does ODBC
> cache recordsets to local hdds or something like that or is poor suspicious
> me being unfair to poor odbc logs? ;-))

May the MS ODBC trace is the problem. I had the same problem. Turn it off, and
the HDD led won't light. The ODBC driver's own log is fast, but I turn it on
only when I really need it.

Regards, Tibor

-- 
Tibor Laszlo
ltibor(at)mail(dot)tiszanet(dot)hu

In response to

pgsql-interfaces by date

Next:From: Francis SolomonDate: 2000-11-29 13:04:51
Subject: RE: slow odbc access....
Previous:From: Peter MountDate: 2000-11-29 09:37:04
Subject: RE: currval() problem

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