Received: from gauss.deltav.hu (deltav.hu [213.163.0.2])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eATB3Xt31297
	for <pgsql-interfaces@postgresql.org>;
	Wed, 29 Nov 2000 06:03:33 -0500 (EST)
	(envelope-from ltibor@mail.tiszanet.hu)
Received: from tir (dial-subscriber-189.deltav.hu [213.163.1.189])
	by gauss.deltav.hu (Netscape Messaging Server 3.6)  with SMTP
	id AABD31; Wed, 29 Nov 2000 12:06:19 +0100
From: Tibor Laszlo <ltibor@mail.tiszanet.hu>
To: Sanjay Arora <sk@pobox.com>
Subject: Re: slow odbc access....
Date: Wed, 29 Nov 2000 12:01:04 +0100
X-Mailer: KMail [version 1.0.28]
Content-Type: text/plain
References: <200011281759.XAA08973@tcs.com>
In-Reply-To: <200011281759.XAA08973@tcs.com>
MIME-Version: 1.0
Message-Id: <00112912044106.02030@tir>
Content-Transfer-Encoding: 8bit
Cc: pgsql-interfaces@postgresql.org
X-Archive-Number: 200011/290
X-Sequence-Number: 327

> 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@mail.tiszanet.hu