| Author |
Topic |
|
Luke101
Starting Member
30 Posts |
 Posted - 2008-07-28 : 22:36:08
|
| Hello,I have been doing a little research on ms sql and mysql. I am trying to justify using ms sql because of its high price. I am in the middle of developing a web application in asp.net and trying to decide whether to use ms sql or mysql. I have noticed sites like wikipedia.com and craigslist use mysql for their database. I have done some benchmarks on both ms sql and mysql. In a windows environment ms sql performs faster then mysql on simple and complex queries. So, now i am going to finish my development in ms sql. But, before I do I just wanted to know if there are any high traffic sites out there that use ms sql.Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-28 : 22:41:19
|
Yes. SQLTeam.com
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Luke101
Starting Member
30 Posts |
Posted - 2008-07-29 : 23:24:41
|
| I thought myspace uses Oracle? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-29 : 23:28:20
|
http://jobs.myspace.com/a/ms-jobs/list/q-Databse+Managermaybe . . they advertise for Oracle DBA, PL/SQL developer
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-07-30 : 05:10:23
|
| So many Big ERP applications running on sql server.Exampls: ramco, exensysArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 12:42:38
|
| The article I read a couple of years back showed the myspace.com architecture. It was using SQL Server 2005 with heavy partitioning across federated servers.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-07-30 : 13:43:00
|
quote:
Originally posted by khtan
Yes. SQLTeam.com
KH[spoiler]Time is always against us[/spoiler]
And SQLTeam uses SQL Server Express, the free edition of SQL Server.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-07-30 : 13:55:09
|
| Here is an article about myspace on SQL Server:http://www.baselinemag.com/c/a/Projects-Networks-and-Storage/Inside-MySpacecom/http://www.baselinemag.com/c/a/Projects-Networks-and-Storage/MySpace-Tech-Roster/Standard database server configuration consists of Hewlett-Packard HP 585 servers with 4 AMD Opteron dual-core, 64-bit processors with 64 gigabytes of memory (recently upgraded from 32). The operating system is Windows 2003, Service Pack 1; the database software is Microsoft SQL Server 2005, Service Pack 1. There's a 10-gigabit-per-second Ethernet network card, plus two host bus adapters for storage area network communications. The infrastructure for the core user profiles application includes 65 of these database servers with a total capacity of more than 2 terabytes of memory, 520 processors and 130 gigabytes of network throughput.CODO ERGO SUM |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-07-30 : 15:59:18
|
| Luke -- how big do you expect your database to be? As mentioned, SQL Express is FREE and is very, very powerful.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
Luke101
Starting Member
30 Posts |
Posted - 2008-07-30 : 18:52:41
|
| wtf...sqlteam uses sql express! I did not know that..I guess I'll use it too. I don't expect my database to get that big but I expect high traffic. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-07-30 : 19:34:03
|
also most all of the microsoft.com sites would be using SQL Server.
elsasoft.org |
|
|
|
|
Any really large high traffic websites use MS SQL
I found a PDF on how Dell uses SQL Server 2005: