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
----- Original Message -----
From: "Byron Nikolaidis" <byron(dot)nikolaidis(at)home(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>; "Sanjay Arora" <sk(at)pobox(dot)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
> when the odbc trace log is on. This has always been the case. I think
> goes out of there way to make sure everything gets logged so it goes right
> to disk for each odbc call, with no buffering.
> ----- Original Message -----
> From: Sanjay Arora <sk(at)pobox(dot)com>
> To: <pgsql-interfaces(at)postgresql(dot)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
> > mbps ethernet network using four eight port cascaded hubs. PG is
> > with BLCKSZ 32 kb.
> > Thanks to all of you I seem to be making some progress in porting my app
> > pg backend. I am facing a peculiar problem.
> > SQL queries through the odbc are extremely slow. Its so noticable that
> > do not even need to bechmark the query execution time. I used simple
> > 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
> > 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
> > the ODBC driver is caching something on the local hdd. I do have the
> > log on but the hdd activity seems to be too intensive for that. Does
> > cache recordsets to local hdds or something like that or is poor
> > me being unfair to poor odbc logs? ;-))
> > Are there any other ODBC drivers on Win32 for PG that I can try? Any
> > 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.
In response to
pgsql-interfaces by date
|Next:||From: Tim Uckun||Date: 2000-11-29 19:00:56|
|Previous:||From: Francis Solomon||Date: 2000-11-29 13:04:51|
|Subject: RE: slow odbc access....|