Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: buckworks
Is PHP fast than ASP? Which one is easier to learn? Is MySQL better than Microsoft SQL? Which one is more secure?
I have fooled around with the ECommerce startup kit from ASP.Net, and right now I'm messing around with osCommerce. I was just curious which way I should go first, ASP or PHP.....
This all depends on what facilities are available to you; how far your business ideas are progressed; what previous development experience you have, what funding you have etc. etc.
There is no straight forward answer.
If you have been programming in Visual Basic for years and writing apps that connect to Access databases via ODBC for example; then you will be feel right at home with an ASP / MS-SQL set-up.
If, on the other hand, you are new to all of this and don't have a huge budget, go the open source option and set yourself up with a Linux box, Apache, PHP and MySQL.
Is PHP fast[er] than ASP?
Too many outside influences to call. Performance of hardware and quality of code (particularly where database development is concerned) has a bigger impact of "speed" than the language you use.
Which one is easier to learn?
Between ASP and PHP, there is no real difference. PHP will come quickly to anyone with a C background, whereas ASP will come quickly to anyone with a VB background.
Is MySQL better than Microsoft SQL?
"No" as the general answer, but this again is subjective to some extent. Microsoft SQL Server is an extremely mature and capable database server, with features, scalability, stability and raw grunt that totally eclipse MySQL in comparison - but with that of course comes expense. For hobby and small scale ecommerce sites you can go a very, very long way with MySQL; but I don't yet know of a global banking corporation that holds your account details on MySQL.
Which one is more secure?
Too many outside influences to call.
Hope that gives you something to think about!
[edited by: dmorison at 9:46 pm (utc) on Oct. 28, 2003]
If you're intending to get an "out of the box" eCommerce solution, then it'll simply (heh) be a case of maintaining and tweaking. On the other hand, if you want to code something from scratch then mess around with the basics of both first, see which you prefer.
I personally can't see anything that really puts one above the other for use, though I'll stick to PHP myself ;-)
Thanks though for the info :)
This relies entirely on who your host is and what they support. I, personally, think that Linux is more stable and a PHP backend will be better for you. However, I am sure a million people will tell you that ASP is much more reliable.
It will come down to what you are most comfortable in, or if you are outsourcing it, what your cheapest option is...
I having shopping carts on both platforms and I find the PHP carts to be far easier to work with, but the biggest thing for me has been the cost of developement:
1) I can often find free modules that I can use in PHP that do exactly what I need
2) I can usually get an answer on forums about modifying code
3) If the above two don't work, I can get an excellent PHP developer to do the work for far less money than I would pay an ASP developer.
I think ASP was once regarded as the premium solution for big clients, and then PHP was thought to be for the small guy. That difference is pretty much gone now.
If you are doing your own programming, then I'd recommend PHP for cleaner and more straightforward coding, particularly for database connection and querying.
To me, ASP seeems overly dependent on object-oriented programming, to where you might need 10-20 lines of code to set up an ADO connection.
Be careful not to underestimate the power of MySQL. There are terabyte MySQL databases out there. Some comparison tests give MySQL the edge over SQL Server for raw power.
Unless you really need triggers and stored procedures, I recommend going with the fast and powerful MySQL. The MySQL Control Center software provides database design features comparable to SQL Server Enterprise Manager.
Did I mention that PHP, MySQL, and Control Center are all FREE downloads you can run under IIS or PWS on your desktop for development?
I agree with you MySQL is overall very good over M$ SQL.
No way. MSSQL blows the doors of MySQL.
I use both MSSQL and MySQL and have never had a performance issue with MSSQL - that can't be said for MySQL. I have seen MySQL go down on intranets and watched it give up the ghost on a popular discussion forum. In both of those circumstances, MSSQL was brought in and saved the day.
Of course, is was not cheap!
I personally use MySQL as my central database and feed it with 7 MS Access databases (yep, I run eComm sites on Access).