Unanswered: Optimum database for Web based applications
Which database is optimum for web based applications?
If there is a webpage, which at any point of time, is accessed by tens of thousands of people across the world. Which database would be better suited to this type of web application where there is huge online traffic?
Can anyone put across how each database like Microsoft SQL, Sybase, Oracle, etc., performs with a Web application, which is
What are the intricacies involved in selecting a database for a Web based application?
Any reference to these details is also appreciated.
The first and perhaps the most importants step for you is... to decide what the selection criteria ought to be. What's important and unimportant to this application? How much load will it receive? What's the budget, the sensitivity of the data and so-on? Under what operating-system(s) will it run?
Perhaps the most critical factor, for a high-volume web database, is that of load balancing and throttling so that the system never attempts to do more than it is physically capable of. e.g.: If 5,000 requests crash in within one second, which is quite possible, but the system is capable of handling only 2,500 and it posesses mechanisms to ensure that only 2,500 requests are attempted (the rest are queued, for a mere one second more), then the system will handle the workload gracefully without popping a piston.
This doesn't involve the DBMS selection directly, but it's definitely part of the overall picture ... and when an un-controlled overload occurs, the DBMS is usually the one that is (wrongly) blamed.