MS Access out-performs PostgreSQL 7?

From: "Joseph Sircy" <webmaster(at)dnhawaii(dot)com>
To: "pgsql list" <pgsql-admin(at)postgresql(dot)org>
Subject: MS Access out-performs PostgreSQL 7?
Date: 2000-07-18 18:28:46
Message-ID: 007e01bff0e6$05dc9630$7f1c8996@hi.pac.army.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I would like to know why access is outperforming pgsql in a simple database setup. I have the exact same databases, one in access, the other in pgsql, on the same server, a linux box running redhat 6.2.
They are being accessed by an asp page running IIS 4 on a NT box ( i cant change that).
The connection between the 2 servers is not the issue, we have made sure of that.
Go to http://www.dnhawaii.com/data_test.asp and see for yourself.
One thing I haven't done is post the source code for the page, but all are simple SELECT or UPDATE sql commands.
Any comments would greatly be appreciated, as I may have to explain to higher ups why we NEED to run linux!!

Joe Sircy
Webmaster
dnhawaii.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message The Hermit Hacker 2000-07-18 18:43:26 Re: MS Access out-performs PostgreSQL 7?
Previous Message miguel valero 2000-07-18 13:25:28 PostgreSQL Functionality