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 #29966 is a reply to message #29956]

Thu, 26 January 2006 15:15

Ilia

Messages: 13241
Registered: January 2002

Karma:

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

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:25:28 GMT 2024

Total time taken to generate the page: 0.04072 seconds