467,925 Members | 2,017 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,925 developers. It's quick & easy.

Microsoft .NET+ SQLServer VS Linux, PHP, mysql => Performance ???

From the article
http://software.newsforge.com/softwa...tid=131&tid=13

"Flickr runs on MySQL, the most popular open source database, and it has
from the beginning. Today Flickr has around a quarter of a million users and
serves around 5,000 pages per minute, generating about 100,000 database
queries. "

Now if we run above scenario in Windows 2003 Web edition and SQLServer 2000
on Windows 2003 Server.
However may server do we need? Web Server how many? SQLServer how many?

5000 pages per minutes
100,000 database query

Can .NET perform as good as Linux PHP MySQL?

Thanks,
Rosny
Nov 19 '05 #1
  • viewed: 1778
Share:
1 Reply
I've got no actual performance data in hand, but as far as I remember MySQL
(I mean version 4 or below) have it's performance outrunned MSSQL and Oracle
server. This is believed mainly because if it's lack of transaction and so
on database infrastructure.

Now consider the following: Since MySQL 5 which supports transaction is
still under development(not production/stable status), if you think
transaction(i.e.: data integrity) is important, you should choose one of the
other SQL servers which supports transaction. If you simply want top notch
speed, choose MySQL.

"Rosny" <se********@hotmail.com> glsD:uh**************@tk2msftngp13.phx.g bl...
From the article
http://software.newsforge.com/softwa...tid=131&tid=13

"Flickr runs on MySQL, the most popular open source database, and it has
from the beginning. Today Flickr has around a quarter of a million users
and
serves around 5,000 pages per minute, generating about 100,000 database
queries. "

Now if we run above scenario in Windows 2003 Web edition and SQLServer
2000
on Windows 2003 Server.
However may server do we need? Web Server how many? SQLServer how many?

5000 pages per minutes
100,000 database query

Can .NET perform as good as Linux PHP MySQL?

Thanks,
Rosny

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Andy Stubbs | last post: by
reply views Thread by mikey | last post: by
8 posts views Thread by wlcna | last post: by
10 posts views Thread by callmebill | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.