Re: prelimiary performance comparison pgsql vs mysql
От | tony |
---|---|
Тема | Re: prelimiary performance comparison pgsql vs mysql |
Дата | |
Msg-id | 1110892078.3668.44.camel@hush обсуждение исходный текст |
Ответ на | Re: prelimiary performance comparison pgsql vs mysql (Mark Rae <mrae@purplebat.com>) |
Ответы |
Re: prelimiary performance comparison pgsql vs mysql
|
Список | 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
В списке pgsql-general по дате отправления: