| From: | tony <tony(at)tgds(dot)net> |
|---|---|
| To: | Mark Rae <mrae(at)purplebat(dot)com> |
| Cc: | Chris Browne <cbbrowne(at)acm(dot)org>, postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: prelimiary performance comparison pgsql vs mysql |
| Date: | 2005-03-15 13:07:57 |
| Message-ID: | 1110892078.3668.44.camel@hush |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le mardi 15 mars 2005 à 12:26 +0000, Mark Rae a écrit :
> >> Clients 1 2 3 4 6 8 12 16 32 64 128
> >> ------------------------------------------------------------------------------
> >> mysql-4.1.1 1.00 1.41 1.34 1.16 0.93 1.03 1.01 1.00 0.94 0.86 0.80
> >> pg-7.4.1 0.65 1.27 1.90 2.48 2.45 2.50 2.48 2.51 2.49 2.39 2.38
> by the time 3 clients are running, postgres is getting through the
> queries 1.90/1.34=1.42 times faster
That is very interesting!!!
I have several webapps on my server each one opens several queries to
the database from _each_ JSP - often more than three... So the hunch
that I had all along was right: PostgreSQL is a much better back end for
Tomcat/JSP than MySQL.
Cheers
Tony
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miroslav Šulc | 2005-03-15 13:15:56 | Re: Localization problems between Access and PostgresSQL |
| Previous Message | Secrétariat | 2005-03-15 12:52:04 | Localization problems between Access and PostgresSQL 8 |