[ADMIN] MS Access out-performs PostgreSQL 7?

[Joseph Sircy]

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