From: | Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com> |
---|---|
To: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Example web access to Postgres DB |
Date: | 2008-02-17 16:22:21 |
Message-ID: | 1203265341.5435.23.camel@aleph.morrison.iserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> > I am looking for an example of a web application (WAR) which executea a
> > Postgres actions. This aims to test the performance of Postgres in Web mode.
> > I shall be grateful if someone gives me a link where I can find a WAR file.
> I think you're going to have to be more specific. I don't know what
> technology uses WAR files, and based on the tepid response, it doesn't
> seem like anyone else on the list does either.
> What program are you using that uses the WAR files?
WAR is a way of packaging J2EE applications for Java app servers like
Tomcat, JBoss, etc... I have no idea what the question is looking for;
there are hundreds, if not thousands, of J2EE applications that use
PostgreSQL (OpenNMS, OpenReports, OpenBravo, JOPE,....). And likely
100% of those connect via JDBC with entirely standard and fairly
database-agnostic code.
And I think a "performance test" from a J2EE application is just as
likely to measure the performance of the particular J2EE platform [and
configuration] then it is to tell you much about PostgreSQL performance.
For performance testing (of the JDBC driver/connection) it would be
better to connect from a simple Java application (without any of the app
server overhead) otherwise you have no idea who/what you are measuring
[unless your a J2EE guru].
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Schuller | 2008-02-18 07:39:46 | Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine |
Previous Message | Dave Cramer | 2008-02-17 16:12:54 | Re: Example web access to Postgres DB |