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

RE: ODBC driver on NT client

From: Craig Orsinger <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: ODBC driver on NT client
Date: 2000-08-03 23:49:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
On 02-Aug-00 Jim O'Rourke wrote:
> Hope someone can assist.  I'm currently running ODBC driver v6.5 against a
> v7.0 backend on Aix 4.2.1.
>  Everythings been running great on Win 95/98 clients for a couple years (Win
> 2000 for a couple weeks), and I was hoping to begin using on NT40 clients as
> well.
> My problem is that 2 minute queries using 95/98/2k clients are taking over
> 30 minutes on bigger/better NT workstation platforms.  I've set and reset
> driver options to no avail.  Seems to my untrained NT eye that the driver is
> chowing memory, and starts heavy paging early in the query.

        I've been using a similar connection to a PostgreSQL database
on a Linux box, and haven't seen degraded performance. In some cases,
it actually seems to perform better than an Access database on the NT
client. In any event, as long as you're using the April 2 version of
the PostgreSQL ODBC drivers, things should be OK. I haven't done
anything special to make this work better (given my cluelessness
about NT internals, I couldn't if I wanted to), but just followed the
instructions on the Pgsql ODBC driver website.

        One possible explanation is that there is something wrong or
different about your NT boxe's network setup. You might try doing
FTP transfers or some other network test that uses lots of TCP
connections and transfers lots of data. Sometimes hardware manufac-
turers don't support NT as well as they support Win95/98, so it's
possible your network card's drivers are suboptimal.

Date: 03-Aug-00  Time: 16:40:29

Craig Orsinger                  (email: <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil>)
Logicon Advanced Technology
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor

In response to

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-08-04 06:42:52
Subject: RE: JDBC driver writes binary data ONLY as Large Object
Previous:From: BillDate: 2000-08-03 19:45:44
Subject: Re: JDBC driver writes binary data ONLY as Large Object

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