From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Jason Tishler'" <Jason(dot)Tishler(at)dothill(dot)com> |
Cc: | Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | RE: ODBC calls seem surprisingly slow... |
Date: | 2001-07-11 14:35:31 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A2D02@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kian Parsee | 2001-07-11 14:57:41 | RE: PostgreSQL on Win/2K |
Previous Message | Jason Tishler | 2001-07-11 14:24:07 | Re: ODBC calls seem surprisingly slow... |