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.