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