From: Adam Tauno Williams <adamtaunowilliams@gmail.com>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Example web access to Postgres DB
Date: Sun, 17 Feb 2008 11:22:21 -0500
Message-ID: <1203265341.5435.23.camel@aleph.morrison.iserv.net> (raw)
In-Reply-To: <20080217101814.f01b2a26.wmoran@collaborativefusion.com>
References: <2e5ec3f0802170321m704415e9oa926eada411b0164@mail.gmail.com>
<20080217101814.f01b2a26.wmoran@collaborativefusion.com>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adamtaunowilliams@gmail.com
Subject: Re: Example web access to Postgres DB
In-Reply-To: <1203265341.5435.23.camel@aleph.morrison.iserv.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox