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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq