I'm about to move a site from an NT server to a Linux server, and I'm ditching the MS SQL Server.
My question is: what are the advantages/disadvantages of MySQL and PostgreSQL? And are there any other reasonable options for Linux?
The site is a political activism network, and will use a database for logging in/out, keeping track of members, keeping a database of public officials, running message boards, and running polls.
Almost all of the queries will be simple ones involving only small amounts of data. Speed is our biggest priority here. I've heard that MySQL is a lot faster than PostgreSQL, but I've also heard the opposite....
Thanks,
Keegan
My question is: what are the advantages/disadvantages of MySQL and PostgreSQL? And are there any other reasonable options for Linux?
The site is a political activism network, and will use a database for logging in/out, keeping track of members, keeping a database of public officials, running message boards, and running polls.
Almost all of the queries will be simple ones involving only small amounts of data. Speed is our biggest priority here. I've heard that MySQL is a lot faster than PostgreSQL, but I've also heard the opposite....
Thanks,
Keegan