RE: ODBC calls seem surprisingly slow... - Mailing list pgsql-cygwin

From Dave Page
Subject RE: ODBC calls seem surprisingly slow...
Date
Msg-id 8568FC767B4AD311AC33006097BCD3D61A2D02@woody.vale-housing.co.uk
Whole thread Raw
In response to ODBC calls seem surprisingly slow...  ("Robby Slaughter" <webmaster@robbyslaughter.com>)
List pgsql-cygwin

> -----Original Message-----
> From: Jason Tishler [mailto:Jason.Tishler@dothill.com]
> Sent: 11 July 2001 15:24
> To: Dave Page
> Cc: 'webmaster@robbyslaughter.com'; Pgsql-Cygwin
> Subject: Re: [CYGWIN] ODBC calls seem surprisingly slow...
>
>
> Dave,
>
> On Wed, Jul 11, 2001 at 02:54:31PM +0100, Dave Page wrote:
> > No, I'm afraid not, only experience. I run PostgreSQL 7.1.2 on
> > Slackware Linux 7.1 for about 25 users using about 5 different
> > databases, plus it logs 5 webservers and 2 busy PBX event logs, and
> > even when that system was running on a 128Mb 450MHz PIII
> (it's since
> > been upgraded) it was
> > *significantly* faster than 7.x.x on Cygwin on my W2K PIII
> 850Mhz laptop
> > with 128Mb, with only me using it whilst developing pgAdmin
> (which is done
> > on the Slackware box when I'm in the office so it's not the
> different use
> > slowing it down).
>
> Your comparison is not apples to apples.  Usually laptop hard
> disks are much slower than desktop ones, which could be
> causing some of the perceived slowness.

Of course, I'm well aware of that, however, having numerous fast boxes
running W2K on 3 1/2" IDE disks (the same make and model as in the Slackware
box) I can compare performance of other (non-postgresql) apps and be fairly
happy that the large amount of money I spent (not mine I hasten to add) was
not wasted. Like I said, it's not performance data, just experience and
judgment based on knowledge and extensive use of the systems involved.

> Nevertheless, like I
> said before, a Cygwin app should be expected to be slower
> than a Linux app on the same hardware. I'll be very
> interested to see Terry's apples to apples comparison, if I
> can help solve the Cygwin DLL (or PostgreSQL) resource leak.  Sigh...

Yes, I'd be very interested as well.


Regards, Dave.

pgsql-cygwin by date:

Previous
From: Jason Tishler
Date:
Subject: Re: Libpq.dll on MinGW, was Re: initdb failure - postgres hangs with 100% CPU
Next
From: Kian Parsee
Date:
Subject: RE: PostgreSQL on Win/2K