Re: MS Access out-performs PostgreSQL 7? - Mailing list pgsql-admin

From David C. Hartwig Jr
Subject Re: MS Access out-performs PostgreSQL 7?
Date
Msg-id 3974B63B.A0D195F7@home.com
Whole thread Raw
In response to MS Access out-performs PostgreSQL 7?  ("Joseph Sircy" <webmaster@dnhawaii.com>)
List pgsql-admin
Joseph Sircy wrote:
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!!

I assume your units a are in seconds.    If so, these numbers seem reasonable; PostgreSQL is doing a bit more than work than Access.    Your test for a LIGHT load indicates this.    You may want to consider how each of these perform under a heavy load.   Or not, if salability is not at issue.

For most of the work I have done using  web based transactions, less than a second response times, are more than good enough.   Most users cannot discriminate these time differences.     Its the other features of the two databases that make the difference.
 
 

pgsql-admin by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: MS Access out-performs PostgreSQL 7?
Next
From: "Joseph Sircy"
Date:
Subject: Re: MS Access out-performs PostgreSQL 7?