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

date posted 10th January 2004 10:35

On Sat, Jan 10, 2004 at 07:24:08AM -0000, Danish Umer wrote:
>
> 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.
oky lets go through the points.


MYSQL , Apache and PHP can be run on either platform . as can PostgreSQL
( which I will come to later ). So lets not compare Linux with Win2k...


Now how about the feature sets.

SQLServer vs MYSQL
Well MySql is actually lightweight for database implementation but for
general CMS and simple ecommerce applications it will beat SQL on the
basis of Cost, Processor Utilization and Management (phpMyAdmin) but
never features.

SQLServer vs PostgreSQL
Here we begin to see some similar feature sets, Triggers, Views,
Constraints, Transactional functions with better granularity. Both
DBMSes feature these so again we can compare how much power the PC will
require to drive the operating system and then the RDBMS. In terms of
management consoles I would have to say that whilst its fine to be able
to graphically represent the links and connections you expect it does
begin to drive up (un)desired complexity by allowing you to easily link
data. So dont be fooled into thinking that a simple GUI interface will
be a benefit.

Growing the database and managing the data set.
Well to be honest Unix based environment will scale better, handle
reduncancy and enable faster recorvery times for whole data and engine
environments.

Occasionally in the year we rebuild Linux and Windows boxes, the Linux
boxes allow us to simply put the data and engines wherever we need them
and move them across PC platforms without any effort. If the user has
bought a DELL/COMPAQ/HP etc machine then if CPU has died (mainboard
failure or system death) we first have to buy new Licenses ( anyone want
to pick a fight on that , please call MS Licensing and ask them about
OEM licensing[1] and how its NON TRANSFERABLE). For those customers whom we
encourage to buy their DELLS without OS installed we usaully have them
purchase a seperate FULL license for Win2k, SQl etc enabling us to
transfer liceneses..

Meanwhile Linux, Postgres, PHP etc allow us to place copies anywhere,
within reason of their licensing.


Next up...

Win2k Web server vs Apache

One webserver requires megabytes of memory and install space the other
requires a few megabytes and about 800k of space. Apache supports 69% of
all http transactions on the web. see Netcraft. Simply put youll need a
bigger box if your going to run a Win2k ASP environment..




And then ....

PHP vs ASP


Both can enable dynamic script creation. however PHP support more
advanced Mail delivery, management features, Graphics creation, writting
to PDF without distillers or FDF licensing.

In the long term ASP will require you to buy more third party components
to enable "features" which is fine until one third party app wont
install next to another, or the third party supplier disspears.



HOW WELL DO THEY SCALE FOR LARGE VOLUME APPLICATIONS

Well if you check out Amazon, Slashdot, 535x, you'll notice that they
are driving many of thousands of transactions and they use less power in
terms of technologies and costs than their Propriatary cousins.


Links.


Check out


www.onlamp.com
www.template-toolkit.org
www.netcraft.com
www.apache.org
www.knoppix.org


Noterata

[1] OEM Licensing .. Is only legal if it is installed my a approved
OEM licensed distributor. Buying a OEM license cheaply at a stall is
actually not legal if you read the copywrite notice. Furhter more FAST
and BSA will penalise you for OEM licenes. Clone PCs require full boxed
off the shelf copies or Off Shelf Multiple license copies. If you buy a
Dell and the main board dies or the whole unit dies then MS require you
to buy another license to have it fixed. Assuming that the warranty for
the Dell has expired. OEM licenses are non transferable and cannot be
allocated or moved. If more people held striclty to the licensing
requirements of MS then more would be using open soucrce at the desktop.

Finally

We have actually built a XBOX modded with Linux, apache, mysql and php
to demonstrate webpage handling on Xboxes and its very cool. £90 for
second hand Xbox, £40 for mod chip. The new versions come with 10Gb hard
drives which is plenty of space for playing around. Of course having it
hosted at a datacentre can get you funny looks.



Any questions ?







>
> 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
>
>