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 1  1931 
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********@hot mail.com> ¼¶¼g©ó¶l¥ó·s»D: uh************* *@tk2msftngp13. phx.gbl... 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Andy Stubbs |
last post by:
Hi,
I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32
(e.g., Xeon) with more than 4 GB RAM? Did you find a performance
enhancement? With PAE mode on? How does this affect MySQL - being a
multithreaded process, is there any benefit in having all that extra
memory as anything other than a big disk cache?
If anybody is familiar with this scenario, I'd be very grateful for your
insights.
|
by: mikey |
last post by:
Hi all,
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.
There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I can not seem to get any of the functions
working on it. So I have now dopwnloaded the latest version hoping
that this will fix the error.
I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but
|
by: wlcna |
last post by:
mysql v4.0.16:
I had been using mysql with innodb and thought that was fine, until i used
it for something requiring a few - perhaps slightly involved - joins, and
have now seen the performance become totally unacceptable.
I have a query that takes over 35 seconds using mysql and innodb, for
reasons that are completely a mystery to me, in a result set consisting of
only a handful of items.
|
by: callmebill |
last post by:
I'm getting my feet wet with making Python talk to MySQL via ODBC. I
started on Windows, and it went smoothly enough due to the ODBC stuff
that apparently is native to Python at least on windows (I've been
following ch. 13 of Mark Hammond's py on win32 book).
But now I'm trying to do equivalent stuff on linux (Fedora Core 3) with
python 2.3.5 and mysql. I'd like to stick with packages that are
native to python, rather than relying on...
|
by: boonkit |
last post by:
Hi all,
I cannot find MySQl performance info at linux "top" command. I already
tested on slow MySQL query that took more than 5 minutes (create
fulltext index), but during the 5 minutes, i cannot find any mysql
process at top command. Below is the system information:
Linux version: 2.6.9-1.667smp (Red Hat 3.4.2-6.fc3)
MySQL version: 4.1.11 (source installation)
| | |
by: Dave Smithz |
last post by:
Hi there,
A new potential client currently run there database on using MySQL and PHP,
it has about 7000 records and runs rock solid over the web.
However they need much more functionality and have approached me to build
them a new database. However, they are used to rock solid reliability in
their quite straight forward database (which is also cheap to run because it
is opensource components), I have not yet implemented any largish...
|
by: Ian Baker |
last post by:
We have developed an Access/Jet database (2000, XP & 2003 versions) that has
been used by clients all around the world for several years and is extremely
robust with 55 tables, 172 hard stored queries (plus about the same in VBA
SQL code), 60 forms and about 18,000 lines of code. The biggest advantage
with Access is that it doesn't cost the client anything for if they don't
have Access already then we provide the Runtime version which makes...
|
by: Yogee |
last post by:
Hello all,
I dont know the exact group where I should post my questions. So, I m
doing it on most of the groups which support components of LAMP stack.
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the
site performance is very slow on windows. I dont know the exact
reasons.
I have seen some benchmark details on internet. But still they are not
|
by: naimishranderi |
last post by:
Hello friends
I am using ASP.NET 2.0 and SQL Server 2000 for DB synchronization(replication) project.
When I am running this web application on local machine it running fine, but when I deploy it using FTP s/w to hosting server I got error following.
Click here to see web page www.aus-business.com/naimish/replication
Parser Error Message: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
