Which one is better in performance ? php/mysql or asp.net/asp/sql server.

[hndlogic]

Hello

I need to ask about the speed and performance of these two:

Which one is better and faster ?

1) PHP with MySQL database (Linux)

2) ASP.NET (Using Code Behind method) with SQL Server. (Win 2003)


If my site gets thousands of visitors a day what should I use. I know the technologies are far different to compare. But the performance is an issue.

Also which database processes queries faster SQL Server or MySQL ?


Thanks.

[Emerick]

Its all going to boil down to which api you are more comfortable with. If you know PHP better than ASP.NET, than you are probably going to write more efficient markup with PHP. On the other hand, it would make sense that ASP.NET would work better with SQL because they share the same manufacturer (MS). So the integration would seem to be more flaweless. But to better answer your question, they are equal in performance, with tons of history, and optimized as ****. I would seriously base it off what you are more comfortable writing.

[hndlogic]

Thanks, but suppose that if I am confident and equally expert in both PHP/MYSQL and ASP.NET/SQL then which one will give me better speed and performance on system level ?

[russell]

running on equal (and good) hardware, mysql cannot come close to the performance and power of sql server -- as long as you are not using the sql express version of sql server.

i've benchmarked php vs .asp.net (C#) on high throughput systems and found little or no difference running on dedicated servers.