Recent
Articles |
Taking Advantage of Open Source PHP MySQL Applications
One obvious solution is to approach a software development company and obtain a custom built product. However to take this approach one needs to first know what features and functionality is desired. Then on the other hand in some instances the need does not...
Programmer Overkill (MySQL)
I have a peeve about MySQL. Oh, not about MySQL directly: it's great. I love it,
it's wonderful, no complaints. It's the people who use it when they don't need
to that get me shaking my...
MySQL 5.0 Available For Production Use
MySQL AB announced the launch of MySQL 5.0 on Monday. The much-anticipated upgrade
is available for download under the open source GPL license. The new version looks
to be loaded with new features too...
How
to Use SQLXML to Retrieve Data From SQL Server Database?
Using SQL Server 2000 and above versions you can retrieve data from SQL Server
in XML format directly from the database. Many XML related features...
Microsoft
Showing Off SQL Server 2005 At Gitex
The world's largest software company let the middle-eastern market take a gander
at the SQL Server 2005 and their development tool, Visual Studio 2005, at the
September edition of the...
|
|
|
01.03.06
MS SQL / MySQL - A Case Study
 By
John Malco
The release of Microsoft SQL Server 2005 on November 7th 2005 created a buzz around the office for IT professionals.
The use of SQL server by businesses as in an in house data server has become increasingly more popular, this same popularity is now beginning to shift to the web hosting industry.
With the release of MS SQL 2005 Microsoft had this to say "Microsoft SQL Server 2005 provides an integrated data management and analysis platform that helps organizations reliably manage mission-critical information and confidently run complex business applications. With embedded reporting and data analysis tools included with SQL Server 2005, companies can gain greater insight from their business information." The norm for hosting companies has forever been mySQL. mySQL is a free license database server which has an easy to use php based interface called phpmyadmin.
The difference in these two database platforms has become more apparent since the release of MS SQL 2005. We will look at two website hosting companies one of which offers only mySQL on a windows server (http://www.6squared.com) and one which offers both a mySQL and MS SQL 2005 database to its customers (http://www.fivecubed.com)
It is very difficult to make a performance comparison between SQL Server 2005 and MySQL version 4.1. The performance of your databases depends upon the experience of the database developers and database administrator rather than the database's provider. You can use both of these RDBMS to build stable and efficient systems. It is also possible to define typical transactions used in inventory control systems such as airline reservation systems and banking systems. After defining these typical transactions, it is possible to run them under the different database management systems working with different hardware and software platforms.
The comparison aspect being looked at here is how the two web hosting companies sell their hosting packages and which company in turn produced a greater number of sales based on its database offerings. Fivecubed.com who offers MSSQL anteed up a large amount of money to host MSSQL for its customers in the hopes that more customers would use the service solely for the MSSQL. The break-even point for Fivecubed.com was $8,000 because they purchased the MSSQL 2005 standard edition processor specific. This puts 6squared.com at a huge advantage over fivecubed.com.
| Realize the true potential of your Internet and Intranet sites. Use SiteExecutive to build, deploy and manage critical content. |
|
Both companies offer hosting for all price levels and incorporate a large array of features, which puts them on a somewhat even playing field if marketing is ignored. Fivecubed.com and 6squared.com were studied over a period of 1 month. The results of their sales from the period beginning November 7th, and Ending December 7th were as follows: Fivecubed.com had new sales of only database additions (not including hosting packages without database access) totaling 189 sales which translates into $2,632. The databases are sold based on two criteria size and quantity. 6squared.com offered its databases free during this one-month period and generated no additional revenue from database sales. This puts 6squared.com ahead of fivecubed.com by $5,368 at the end of one month by not purchasing MS SQL server.
Now for a projection of sales by fivecubed.com's finance department. They determined a growth rate of 10% per month for the next 24 months. At the end of this time the total number of databases sold will equal 1,692.36, which translates into $13,538.88. As long as these forecasts hold fivecubed.com will reach its break even point by the 18h month and will turn a profit on the 19th month.
The demand for MSSQL shown in the first month that fivecubed.com implemented it was enough to create a profit after only 18 months.
About the Author:
For more information please contact http://www.fivecubed.com
John Malco has been in the hosting industry for over 10 years.
http://www.fivecubed.com
|
