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

RE: ODBC calls seem surprisingly slow...

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: (view raw, whole thread or download thread mbox)
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.

pgsql-cygwin by date

Next:From: Kian ParseeDate: 2001-07-11 14:57:41
Subject: RE: PostgreSQL on Win/2K
Previous:From: Jason TishlerDate: 2001-07-11 14:24:07
Subject: Re: ODBC calls seem surprisingly slow...

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