Re: slow odbc access.... - Mailing list pgsql-interfaces

VB6 uses the "jet" interface.  I had some similar problems not long ago with
Oracle.  They almost scrapped the project until we learned how to tune the
jet engine for the application.

If you use Access and link the table, they run the query from there are you
getting the same problems?

There are some registry hacks for jet that may help.  What MS OS are you on?
Is the ODBC manager up to date?  If you are on NT 4.0 what service pack
level are you on?

How large is the result from the query?

http://www.microsoft.com/data/

has a lot of resources to troubleshoot ODBC problems.

Start the postmaster up with with tracing and also turn tracing on in the
ODBC manager.  Compare and contrast these files after the query to see if
anything funky shows up.  Trace logs can be your good friends when it comes
to ODBC.

For the record I am running ODBC Manager 3.520.5303.2 and the Insight
Distribution Systems driver 6.50 for Postgresql on a Win2k machine.

----- Original Message -----
From: "Sanjay Arora" <sk@pobox.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, November 28, 2000 11: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.
>