Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : PHP + MYSQL + Linux vs ASP + MS SQL + Win 2003

[Ron]

What are the pros and cons?

[Xeentech]

I'm SURE this must have been covered already.. use the search took Ron

[That Guy]

PHP - free, easy to use and learn, very popular
MySQL - VERY popular database, easy to use and well documented
ASP - Not free in most cases, but is still a pretty powerful language with slightly different syntax than other programming languages like PHP
MS SQL - No idea...

I think it depends on your personal preference. Honestly, I enjoy ASP; the syntax is fun to use for me. Never used MS SQL though, so I can't really tell much about that...why exactly do you want to know the pros and cons? If you gave a bit more detail maybe the people here could help you more thoroughly.

[billorly]

I used to be a ASP.net 2.0 C# programmer, and I used to use MSSQL 2005. I liked the full-text search functionality and the actual programs that used to manage the MSSQL database and that is about all. To be honest it's really a big trade off between what you like more. The IDE that you can use for ASP.net is much better then anything you will find for PHP. But at the same time PHP is so darn lax that you can get away near anything in it. That is curse and a blessing all at the same time. I really used to like how I could actually press f9 to make the program stop to debug at a line of code, and press f5 to start and actually step through the code line by line and examine the variables. Also, intellisense is a huge plus (it's what helps you along in Visual Studio as you write code). I can guarantee that I code can be written much faster in C# ASP.net then any other language, but there are a lot of other disadvantages to using it though.

Disadvantages:
1) Cost. Windows boxes are going to run you more money (usually). Also legimately purchasing Visual Studio costs quite a bit, and if you aren't going to use VS then don't even think about it.

2) Efficiency. I could reference a page that shows PHP being faster then ASP.net, but that is common knowledge, so therefore I am not going to. As for MySQL vs MSSQL, those have to be pretty close to even, although I am sure most tests would show MySQL beating MSSQL.

3) Strictness. All languages ASP.net can handle are much more such then PHP. Enough said.

[Ron]

Originally Posted by billorly

I liked the full-text search functionality and the actual programs that used to manage the MSSQL database and that is about all.

What do you mean by full-text search functionality?

Won't MYSQL allow you to do this?

[billorly]

Well full-text search is like searching within an SQL field directly from your SQL query. Actually I just learned that MySQL now supports this too. So pretty much there isn't a lot of different in MSSQL and MySQL... except that with different versions of MSSQL you have various limitations depending on which package you choose. But MySQL is free and great though.

[jt2377]

Originally Posted by billorly

I

2) Efficiency. I could reference a page that shows PHP being faster then ASP.net, but that is common knowledge, so therefore I am not going to. As for MySQL vs MSSQL, those have to be pretty close to even, although I am sure most tests would show MySQL beating MSSQL.

you need to run php scrpt everytime it is process on the server while asp.net is load once since it's compiled. where did you get the php is faster than ASP.net? Do you have something to back it up other than "common knowledge"?

http://en.wikipedia.org/wiki/ASP.NET

"Performance

ASP.NET aims for performance benefits over other script-based technologies ( including ASP Classic ) by compiling the server-side code to one or a few DLL files on the web server. This happens transparently in the background the first time a page is requested (i.e., the developer need not perform a separate compilation step for pages). This provides the ease of development offered by scripting languages with the performance benefits of a compiled binary.

The ASPX and other resource files are placed in a virtual host on an Internet Information Services (or other compatible ASP.NET servers; see Other Implementations, below). The first time a client requests a page, the .NET framework parses and compiles the file(s) into a .NET assembly and sends the response; subsequent requests are served from the dll files.

Developers can also choose to pre-compile their code before deployment, eliminating the need for just-in-time compilation in a production environment."

[billorly]

Well, yeah that is true. I guess I should have specified specifically what I meant. As is ASP.net can actually wipe out PHP because pages are compiled vs. interpreted, but with Zend the code is compiled. ASP.net unnecessarily wastes memory and clock cycles. PHP + Zend is known to be faster then ASP.net. No joke, I very much like writing code in ASP.net, but I hate paying extra for a windows host. C# is a great language, but it's still oh-so strict. A good compromise for me would probably be JScript .net. Although it isn't an OOP language, it is a lazy language though, so I could learn to deal.

[eu_host]

I go for php mysql. why ? simple. It is free and if you have problems with your own code () it is very easy to find help.

[realmetrics]

Linux Vs Win 2003

This will be an ongoing discussion but here is what I think.

Linux - free, security, protect pc from virus, spams, spywares.
Windows - Money, low-security.

PHP Vs. ASP

PHP: Faster, Free, Extras are many and free, cross-platform.
ASP: Limited by COM-object model, Money, Extras are Limited and cost money, Supports only windows platforms.

Mysql Vs. MS SQL

Mysql - Compatible with all other server side scripts
MS SQL - Supports only with scripts developed by microsoft.

Linux, PHP, Mysql are all around better choice than windows, ASP, MS SQL.

Cheers!!!

[M3TechSolutions]

PHP, MySQL and Linux, are the best solutions in my opinion. I love open source. and I also love free stuff too! =P Plus with the MS stuff, you have to pay for those rediculous CAL's for EVERY potential user you have. And plus last time I checked Linux never gets a blue screen =)

[JustinH]

Originally Posted by realmetrics

Linux Vs Win 2003

This will be an ongoing discussion but here is what I think.

And it's dead wrong. Let's continue.

Linux - free, security, protect pc from virus, spams, spywares.
Windows - Money, low-security.

The only truth in this is that Linux (without a support contract) is free, while Windows is not.

Linux is not natively any more secure than Windows, for a variety of reasons. It is the responsibility of a solid system admin to secure an operating system. Windows can be a very secure operating system, as long as a competent admin is running it.

The idea that Linux is better at preventing Spam is simply stupid. Spam has nothing to do with the underlying operating system.

Spyware is equally stupid, since spyware requires installing software, which an end-user does not have the capability to do.

PHP Vs. ASP

PHP: Faster, Free, Extras are many and free, cross-platform.
ASP: Limited by COM-object model, Money, Extras are Limited and cost money, Supports only windows platforms.

Again, you got one thing correct. .NET is limited to Windows at this point. However, PHP is NOT natively faster. On the contrary, due to PHP's tendency to let absolutely crappy code run just fine, I've found it much easier to create bottlenecks.

.NET's limitation to the COM object is actually a feature, since it's an underlying feature of Windows. And .NET does not cost anything as long as you've already purchased a proper version of Windows.

And to say Extra's are limited is hilarious. While the majority of good ones do cost money, implementation is key. I don't mind working with commercial companies, it seems some do.

Mysql Vs. MS SQL

Mysql - Compatible with all other server side scripts
MS SQL - Supports only with scripts developed by microsoft.

And this shows how little research you've done. Every scripting language currently available has the capability to talk to MS SQL servers, that includes PHP, Python, Java and Ruby, none of which were developed by MS.

Linux, PHP, Mysql are all around better choice than windows, ASP, MS SQL.

Cheers!!!

At the end of the day, how many Fortune 500s are using PHP? Yahoo? While PHP can be a GREAT language so can the .NET platform.

Besides, at the end of the day, a real programmer learns Python .

[JustinH]

Originally Posted by M3TechSolutions

PHP, MySQL and Linux, are the best solutions in my opinion. I love open source. and I also love free stuff too! =P Plus with the MS stuff, you have to pay for those rediculous CAL's for EVERY potential user you have. And plus last time I checked Linux never gets a blue screen =)

Every potential user with direct access to the system. This does not include some guy with a web site. Only people accessing the operating system directly needs a CAL.

And since using Server 2003, I've NEVER gotten a blue screen. On XP, I've gotten exactly 1 blue screen (which was ATI's crappy drivers).

Come on folks, if you are going to comment, make it somewhat educated. It's okay to say you don't have much experience with Windows, or you prefer PHP because it's free, but don't randomly make up non-existent "bad things" to try and convince someone.

That being said switch to Python.

[realmetrics]

Hi Adorno,

I’d like to remain the topic of this page. It’s PHP + MYSQL + Linux vs ASP + MS SQL + Win 2003. This topic is not about python.

Anyway I think you are python programmer. Great..

I know, both PHP and Python are entirely different in syntaxes. I'm more productive in PHP but I've not used Python yet.

Cheers!!!

[JustinH]

Originally Posted by realmetrics

Hi Adorno,

Actually, I'm not Adorno. He's another member on here and my signature is a friendly jab at him .

I’d like to remain the topic of this page. It’s PHP + MYSQL + Linux vs ASP + MS SQL + Win 2003. This topic is not about python.

I'm aware of that. It's programmer humor.

Anyway I think you are python programmer. Great..

No, I'm a programmer. The language I use in any given situation is based on a clients needs. Programming languages are just tools, and any programmer worth his salt will learn a programming language relatively easily.

I know, both PHP and Python are entirely different in syntaxes. I'm more productive in PHP but I've not used Python yet.

Cheers!!!

You're the majority I'd guess. PHP's syntax allows for very sloppy syntax, which makes it really easy to learn.