I posted a question on a .net forum and got this reply:
"If you switched for MySql to MS SQL, used stored procedures, and converted the PHP code to ASP.NET, I'm sure you'd get a much faster execution time. Not to mention your source code will be way more organized and readable.
ASP.NET only compiles the code once (the first time it's run). After that, every request for the page calls the compiled code. So you don't need to worry about compile time.
I programmed PHP/MySql for about three years back in the day when it was still fairly new. Recently I've been toying with ASP.NET (I was never a big fan of ASP, mind you). I have to honestly say, ASP.NET just destroys PHP. Especially since it's all part of the .NET framework and all the code is basically the same no matter if you're programming a windows application or web application. It's good stuff.
Just to be fair, though, I haven't run any benchmarks to compare PHP and ASP.NET speed. But since ASP.NET is compiled I have no doubt it'll be faster. And, well, MS SQL > MySql period."
It seems silly that the php interpreter has to re-interpret everything each time a page is requested, surely it does the same as ASP.NET? Does anybody know? And Is MS SQL really faster than MySQL? 8O