RE: FN-FORUM: PHP-Mysql-Linux vs ASP-MS SQL Server-Win2000

date posted 10th January 2004 08:27

Very very large ? How big exactly ?

Given that the DB hierarchy is (I guess);

XML / Text Files
MS Access =20
MySQL
SQL Server
Oracle

There's a fair overlap between mySQL & SQL Server, but SQL Server
(Please flame / correct if I'm wrong here guys) is more scaleable than
MySQL. You'd really have to have a huge amount of data to need Oracle.
And it's feckin expensive.

The advantages of MySQL is that it's free, but then so is the MSDE
version of SQL Server.

PHP is free, ASP is free (yes it is...)
PHP is relatively platform independent, ASP is tied to MS systems (IIS
or PWS) so this is where it's cost arises
Linux is platform independent and "free", MS O/S's (server systems)
aren't cheap.
MySQL is open source and pretty well supported - both on the web and
"paid"
SQL Server is MS propritry and well supported and does (AFAIK) have a
richer feature set than MySQL - it's a question of whether you'd use
those features. Somebody will have to enlighten me as to if mySQL
provides stuff like Stored Procedures, User Defined Functions,
Transaction Handling and Replication.

It's going to largely come down to who you are using for hosting (if
that's already been decided) and who's doing the development, the skills
involved, etc.



Andy
IWD2 LLP
[EMAIL REMOVED]
=20
-----Original Message-----
From: Danish Umer [EMAIL REMOVED]
Sent: 10 January 2004 07:25
To: Andy Macnaughton-Jones
Subject: FN-FORUM: PHP-Mysql-Linux vs ASP-MS SQL Server-Win2000


Hi,
Can any one tell me or refer the URL regarding the benefits and drawback
of both PHP-Mysql-Linux and ASP-MS SQL Server-Win2000 and which is best
for very very large database as well as security and speed.

Regards
Danish

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.=20
http://join.msn.com/?page=3Dfeatures/featuredemail


--
** Get all the Freelance Work you Can Handle * The Web Design Business
Kit will show you proven tactics and strategies for marketing your
business, winning bids, managing projects and pricing your work. Free
Shipping Worldwide.
Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4

To advertise here: http://www.freelancers.net/advertising.html