Wikipedia PHP script: Difference between revisions

Revision as of 22:08, 15 November 2001

Revision as of 06:41, 6 December 2001

Line 68:

:I'll stick to the MySQL version for now, since I have barely the time to maintain that one alone right now. Once it is up at this site (probably early January), and has no real bugy anymore, I could try PostgreSQL at a test site and convert it if it is really faster. --[[Magnus Manske]]

If the app. relies much on any complex joins, than PostgreSQL will probably be able to outperform MySQL. If it's mostly simple selects from a single table, than probably not. But as the number of users increases, PostgreSQL handles locking issues much better through its Multi-Version Concurrency Control, which is essentially better than row-level locking. So if you get the chance and time permits, I think it would be worthwhile to give PostgreSQL a try. --[[Wesley]]

----