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

date posted 10th January 2004 15:43

i might as well wade in :D

for the ASP vs PHP, PHP wins - it parses faster, theres plenty of free
class libraries out there as opposed to commercial components you use
with ASP, and its not in the process of being depreciated.

the things that really annoys me with PHP is that its connectivity is
very much tied to individual databases, when there really ought to be
another layer entirely dealing with that, and that it has a lot of
functionality tied to mysql - exactly the kind of lock-in logic M$ gets
derided for.

as for mysql vs SQL server, SQL server every time. mysql is nowhere
near as functional with its lack of triggers, views and sprocs -
although they are coming (the 5.0 alpha has basic sproc support). mysql
has a smaller footprint, but then again considering it doesn't have a
tenth of SQL servers functionality thats not overly surprising is it?

server-wise, well linux is inherently more secure *as long as you have
an admin who knows what they're doing*, that said a linux exploit is
likely to be less damaging that a windows exploit. the most important
thing is ensuring whoevers looking after the network is capable, you can
make a windows box bulletproof with the right network admin, and a linux
box an open invitiation with the wrong one...

so ideally i'd look at hosting the site using PHP on a linux server,
connecting to a windows box with sql server on, imo your web server and
database server should be seperate anyhow so you can have the database
server only accessable via the internal network.

my 2p.

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.
>
> Regards
> Danish
>
> _________________________________________________________________
> Add photos to your messages with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
>