FUDforum: How To » postgresql vs mysql

Home » FUDforum » How To » postgresql vs mysql

Show: Today's Messages :: Polls :: Message Navigator

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:

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

[Message index]

		postgresql vs mysql By: besonen on Mon, 23 January 2006 22:53
		Re: postgresql vs mysql By: Ilia on Tue, 24 January 2006 18:40
		Re: postgresql vs mysql By: besonen on Wed, 25 January 2006 02:05
		Re: postgresql vs mysql By: Ilia on Wed, 25 January 2006 14:23
		Re: postgresql vs mysql By: besonen on Wed, 25 January 2006 18:06
		Re: postgresql vs mysql By: Ilia on Thu, 26 January 2006 15:15

Previous Topic:	easy to export database to other forums?
Next Topic:	Backup query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:39:04 GMT 2024

Total time taken to generate the page: 0.03906 seconds