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

Re: slow odbc access....

From: "Byron Nikolaidis" <byron(dot)nikolaidis(at)home(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>, "Sanjay Arora" <sk(at)pobox(dot)com>
Subject: Re: slow odbc access....
Date: 2000-11-29 00:36:34
Message-ID: 001801c0599c$6d485100$6401a8c0@byron (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(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 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.
>


In response to

Responses

pgsql-interfaces by date

Next:From: tonyDate: 2000-11-29 01:16:08
Subject: currval() problem
Previous:From: Joseph ShraibmanDate: 2000-11-28 23:55:44
Subject: Re: postgreSQL and javascript

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