From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: pgsql-interfaces@postgresql.org
To: Sanjay Arora <sk@pobox.com>
Subject: Re: slow odbc access....
Date: Tue, 28 Nov 2000 19:36:34 -0500
Message-ID: <001801c0599c$6d485100$6401a8c0@byron> (raw)
References: <200011281759.XAA08973@tcs.com>
I have seen really really slow access AND the hard drive light on constantly
when the odbc trace log is on. This has always been the case. I think MS
goes out of there way to make sure everything gets logged so it goes right
to disk for each odbc call, with no buffering.
Byron
----- Original Message -----
From: Sanjay Arora <sk@pobox.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, November 28, 2000 6:33 PM
Subject: [INTERFACES] slow odbc access....
> I am using postgreSQL v. 7.0.2 on RH Linux 6.2 on the server with VB6
> Application accessing the DB through postgrSQL ODBC driver v. 6.50 on a 10
> mbps ethernet network using four eight port cascaded hubs. PG is
recompiled
> with BLCKSZ 32 kb.
>
> Thanks to all of you I seem to be making some progress in porting my app
to
> pg backend. I am facing a peculiar problem.
>
> SQL queries through the odbc are extremely slow. Its so noticable that you
> do not even need to bechmark the query execution time. I used simple
select
> query using where....no joins etc. Same query on psql through telnet was
> noticably faster. At first I thought it was a Network problem and tested
> the query at night with only the server & workstation switched on at
night.
> Problem was not resolved so I ruled out NW issues.
>
> 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? ;-))
>
> Are there any other ODBC drivers on Win32 for PG that I can try? Any other
> issues that I should study?
>
> BTW, when would the PG 7.1 be coming?
>
> Once again, I would like to extend my thanks to all who helped me.
>
> With regards.
> Sanjay.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, sk@pobox.com
Subject: Re: slow odbc access....
In-Reply-To: <001801c0599c$6d485100$6401a8c0@byron>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox