MS SQL vs free Databases

Hello

I need to write an application which must use a database system as a backend, but i have not choosed which one to use. MySQL and PostgreSQL has all the features i want. the most important is database performance. anyone has an idea which database performs faster?

thanks in advance

Well, since you're on the MSDN forums, I'll go ahead and recommend the obvious: try SQL Express or MSDE :-)...|||

Hi,

well SQL Server Express is very powerful, fast, and has rich features. There are normally other conditions that have to be kept in mind while decideing, but if you ask people in a MSDN group, I would say go the Express Way :-)

-Jens Suessmeyer.

http://www.sqlserver2005.de

|||

If you are writing an app from scratch, I'd say you are by far best of using .NET development on a SQL Express platform. You are dealing with the latest and most efficient development platform, the most supported platform, and one that is expandable down the road. And it is cheap to get in at entry level

If you hit a home run, you want to at least have the option of scaling up and up all the way to SQL Enterprise with failover clustered servers.

I don't dream too big, do I? ;-)

|||

A major consideration for your choice of database should include not only features and performance, but the development environment. You really need to consider the OS, programming languages, and tools that you want to use. If you have developers who are proficient with Microsoft technologies (i.e., .Net) then SQL Server is an obvious choice. SQL Server and .Net provide everything you need and there is a ton of documentation, sites, books, webcasts, etc. ad nauseam.

PostgreSQL is powerful and interesting. It supports many languages (C, PL/Python, PL/Perl, PL/pgSQL), but development in the open-source environment is a radical shift from the widespread commercial support of MS or Oracle. You will need to be very proficient at coding many things from scratch, finding open-source tools and support sites, etc. Also, while learning PostgreSQL, I found that it's backup and recovery features were years behind Oracle. So, if your application will be enterprise class, you need to closely examine backup and recovery and high availability features. If your production database goes down, "who you gonna call"? (BTW, there are lists you can subscribe to to get email support from the PostgreSQL developers, but it's not "official" support like you get with MS or Oracle.) Check out www.postgresql.org as a starting point. I cannot recommend highly enough the PostgreSQL Bootcamp at www.bignerdranch.com.

I don't know Jack about MySQL.

Good luck and choose wisely!

|||

i can study u plen.