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

Re: MS Access out-performs PostgreSQL 7?

From: "David C(dot) Hartwig Jr" <dchartwig(at)home(dot)com>
To: Joseph Sircy <webmaster(at)dnhawaii(dot)com>
Cc: pgsql list <pgsql-admin(at)postgresql(dot)org>
Subject: Re: MS Access out-performs PostgreSQL 7?
Date: 2000-07-18 19:55:40
Message-ID: 3974B63B.A0D195F7@home.com (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-admin by date

Next:From: Anthony E . GreeneDate: 2000-07-19 03:04:19
Subject: Re: MS Access out-performs PostgreSQL 7?
Previous:From: Joseph SircyDate: 2000-07-18 19:52:54
Subject: Re: MS Access out-performs PostgreSQL 7?

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