RE: ODBC calls seem surprisingly slow...

> -----Original Message-----
> From: Jason Tishler [mailto:Jason(dot)Tishler(at)dothill(dot)com]
> Sent: 11 July 2001 15:24
> To: Dave Page
> Cc: 'webmaster(at)robbyslaughter(dot)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.