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

date posted 10th January 2004 09:00

Hi Andy,
Thanks for giving your advices.....actually I want to develop a system using
PHP and Mysql on Linux...and the database will be very large...my minimum
approximation is that the database will contain more than 200000 records.
Thats why I want to know that can PHP and Mysql on linux can produce results
better then ASP and SQL Server in terms of Hosting Prices, Security and
Database Activities. What you suggest ?

Regards
Danish

>From: Andy Macnaughton-Jones [EMAIL REMOVED]
>Reply-To: [EMAIL REMOVED]
>To: "FN-FORUM / [EMAIL REMOVED] [EMAIL REMOVED]
>Subject: RE: FN-FORUM: PHP-Mysql-Linux vs ASP-MS SQL Server-Win2000
>Date: 10 Jan 2004 09:07:49 -0000
>
>
>Very very large ? How big exactly ?
>
>Given that the DB hierarchy is (I guess);
>
>XML / Text Files
>MS Access
>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]
>
>-----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*.
>http://join.msn.com/?page=features/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
>
>
>--
>** 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
>
>Unsub: http://www.freelancers.net/rm.php?gÇ5DC9976AE529D36EDD
>
>To Post a New Message: [EMAIL REMOVED]
>Forum Homepage: http://www.freelancers.net/forum.php
>
>http://www.freelancers.net - freelancers and freelance jobs
>

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail