postgresql vs mysql [message #29911] |
Mon, 23 January 2006 22:53 |
besonen
Messages: 11 Registered: June 2005 Location: Oregon, U.S.A.
Karma: 0
|
Junior Member |
|
|
[last question for the moment]
is there a general consensus regarding a preferred database for fudforum?
|
|
|
|
|
Re: postgresql vs mysql [message #29944 is a reply to message #29943] |
Wed, 25 January 2006 14:23 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
MySQL provides the faster interface for uncomplicated queries and with innodb also provides row level locking. Which means that there is a lot less overhead then in PostgreSQL. Furthermore, FUDforum is capable of making use of MySQL 4.1 tricks that in some cases allow elimination of some queries all together.
FUDforum Core Developer
|
|
|
Re: postgresql vs mysql [message #29956 is a reply to message #29944] |
Wed, 25 January 2006 18:06 |
besonen
Messages: 11 Registered: June 2005 Location: Oregon, U.S.A.
Karma: 0
|
Junior Member |
|
|
Ilia wrote on Wed, 25 January 2006 06:23 | MySQL provides the faster interface for uncomplicated queries and with innodb also provides row level locking. Which means that there is a lot less overhead then in PostgreSQL. Furthermore, FUDforum is capable of making use of MySQL 4.1 tricks that in some cases allow elimination of some queries all together.
|
thanks for answering my questions. it's helping me to feel comfortable about making decisions that i may have to live with for a long time. here's a few more db related questions if you are still willing.
[note: i'm not looking to devolve this into a mysql vs postgresql discussion, just wanting to gain a little more understanding of the degree to which improved fudforum performance is a function of using mysql]
so fudforum can't use postgresql's row-level locking? and how about postgresql's mvcc? if postgresql's row-level locking and mvcc are not options atm, are they on the roadmap?
would you say on average that mysql allows fudforum to perform at least 50% faster when using postgresql?
if i choose to use mysql, does fudforum require both mysql-server and mysql-client, or just mysql-server (i'm using debian)?
[Updated on: Wed, 25 January 2006 18:39] Report message to a moderator
|
|
|
Re: postgresql vs mysql [message #29966 is a reply to message #29956] |
Thu, 26 January 2006 15:15 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
FUDforum can and will use PostgreSQL row-level locking, however you need to realize that in situations where queries are very fast, row level can be a hinderence, since the locking overhead will exceed the benefit gained. In all but VERY large forums, row-level locking will actually result in a slight but noticeable performance decrease.
I don't want to commit to a particular number, generally MySQL seems to perform 30-70% faster then PostgreSQL when it comes to majority of FUDforum installation.
FUDforum needs to talk to MySQL server via PHP, so assuming you have mysql extension enabled all you need is MySQL server.
FUDforum Core Developer
|
|
|