RE: ODBC calls seem surprisingly slow...

> -----Original Message-----
> From: Jason Tishler [mailto:Jason.Tishler@dothill.com]
> Sent: 11 July 2001 14:31
> To: Dave Page
> Cc: 'webmaster@robbyslaughter.com'; Pgsql-Cygwin
> Subject: Re: [CYGWIN] ODBC calls seem surprisingly slow...
>
>
> Dave,
>
> On Wed, Jul 11, 2001 at 08:32:23AM +0100, Dave Page wrote:
> > I personally find that Cygwin PostgreSQL is only really
> fast enough as
> > a
> > (very) convenient development platform (<ducks> sorry
> Jason! But it is
> > *very* useful and appreciated).
>
> Thanks, I'm glad that you find Cygwin PostgreSQL useful.  No
> need to apologize to me -- I just submitted some Cygwin
> related patches. Anything running under Cygwin is slower than
> a Linux app running on the same hardware.  Posix emulation is
> almost guaranteed to be slower than real Posix.
>
> Terry Carlin (from Great Bridge) is doing some PostgreSQL
> benchmarking and hopefully will be reporting on Cygwin
> PostgreSQL performance versus other platforms soon.  Do you
> have any data that you can share with the list in the meantime?

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).

But like I said, your efforts are very much appreciated, without them, there
are 15,000+ (seriously - my fingers hurt!) lines of code for the new version
of pgAdmin that wouldn't have been written.

Regards, Dave.