From: Neil P Davis <npdavis@hotmail.com>
To: Byron Nikolaidis <byron.nikolaidis@home.com>
To: pgsql-interfaces@postgresql.org
To: Sanjay Arora <sk@pobox.com>
Subject: Re: slow odbc access....
Date: Wed, 29 Nov 2000 10:50:37 -0500
Message-ID: <OE54bjQ3SI5XnoT8MbS00002237@hotmail.com> (raw)
References: <200011281759.XAA08973@tcs.com>
<001801c0599c$6d485100$6401a8c0@byron>
Hello,
It has been my experience (and this is documented in MSDN) that ODBC Tracing
will KILL your performance! Turn that off and try it again. It is for
debugging only...
L8,
Neil
----- Original Message -----
From: "Byron Nikolaidis" <byron.nikolaidis@home.com>
To: <pgsql-interfaces@postgresql.org>; "Sanjay Arora" <sk@pobox.com>
Sent: Tuesday, November 28, 2000 7:36 PM
Subject: Re: [INTERFACES] slow odbc access....
> 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: npdavis@hotmail.com, byron.nikolaidis@home.com, sk@pobox.com
Subject: Re: slow odbc access....
In-Reply-To: <OE54bjQ3SI5XnoT8MbS00002237@hotmail.com>
* 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