News for hackers. Stuff that matters.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by earle on Monday June 21, 2010 @10:19AM (#1448844)
Why is this a surprise to anyone? And Nginx to memcache will be even faster... and serving static content even faster...

You're adding a tremendous amount of overhead with any high level language stuck in between the connect and the data source.

This is about as basic as it gets, not worthy of #1 item on hacker news.

Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by regularfry on Monday June 21, 2010 @10:27AM (#1448882)
The idea that you might not need the high-level language in the middle at all is interesting in itself. At least, it is to me. I've not seen it before.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by earle on Monday June 21, 2010 @10:36AM (#1448913)
This is working backwards. You do realize that before PHP and higher level languages this is how things generally worked to begin with (server modules) as opposed to now (higher level languages).

I still don't understand why this is on hacker news, let alone the top of the list.. seems to be about the most obvious item of all..

disappointing

Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by thwarted on Monday June 21, 2010 @10:50AM (#1448956)
Isn't this still how things work if you want to do anything easily with Microsoft's IIS?
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by wrs on Monday June 21, 2010 @07:09PM (#1450379)
If you're also using Microsoft SQL Server, it essentially has this capability (using XML not JSON): http://msdn.microsoft.com/en-US/library/ms188266(v=SQL.90).a...
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by henrikschroder on Monday June 21, 2010 @12:52PM (#1449321)
Yes, you can write an ISAPI module if you want as little as possible between your program and IIS, but I wouldn't label that as "easily".

And I don't see why you would bother, ASP.Net is compiled, it's not exactly a performance hog, unlike PHP.

Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by pjscott on Monday June 21, 2010 @03:10PM (#1449720)
I haven't used them, but there are a variety of PHP compilers, like phc or Facebook's HipHop. I hear that they can really speed up PHP code.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by cookiecaper on Monday June 21, 2010 @09:07PM (#1450581)
I can't really tell from the phc page, but HipHop at least doesn't "speed up PHP code". It converts the code from PHP to C++. That isn't speeding up PHP, that's unraveling the PHP and respinning it as C++.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by regularfry on Tuesday June 22, 2010 @07:08AM (#1451523)
It's still speeding up PHP by compiling it, it's just using C++ as an (extra) intermediate representation.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by apgwoz on Monday June 21, 2010 @10:34AM (#1448910)
You haven't seen PHP or Python between MySQL and the webserver? I must be missing your point.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by regularfry on Monday June 21, 2010 @11:51AM (#1449127)
The reverse - I can't remember having seen a database spew JSON from port 80 before without an intervening HLL.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by apgwoz on Monday June 21, 2010 @01:17PM (#1449405)
That makes more sense. Thanks for clarifying.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib... by buro9 on Monday June 21, 2010 @10:24AM (#1448869)
You're kidding me right? I'm off to re-write my entire app as a stored proc ;)

You are right of course. But what would be nice would be to replace part of a static page with the result of a piece of SQL. To combine ESIs with MySql so that you can serve static files and still be able to add things like watermarks using a MySql lookup based on a session cookie.