Please note that money is not an object in this matter. I want to compare the two based on experience and features. The particular version of MS that I am referring to is the 2005 version of MSSQL, and the most up-to-date version of MySQL. Speed difference in processing any amount of records.
Search the acrhives, this has been answered hundreds of time. Aside from that your question is too broad so you will only get broad answers which won't really help you. The only use case requirement you specify is money is not relevant, then go for the DB that has the features YOUR USE CASE NEEDS. Which is typically unique and can't be compared to others.
Yeah your right. I just found a post similar to this one but it wasn't what I was looking for. I need to be able to process roughly 10 - 25 million queries a day. But I will see. Thanks
That would be no problem with either assuming the hardware is decent. It's not extremely difficult to get a single server MySQL database up to about 2000 per second, which would equate to 7.2M per hour. It will also be heavily dependent on whether your queries are reads or writes. In either case the load is high enough that it will most likely take a decent dedicated server. Also, if the database server is separate from the application server, you may run into bandwidth limitations. Another thing to consider.
What you are looking for? What sort of queries you want to process? Are these FULLTEXT searches, simple index based searches or complex queries invloving multiple tables of GBs in size? How big DB you are going to host? The work around to this limitation is to connect application server and DB server with private LAN.