Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib...
by IgorPartola on Monday June 21, 2010 @01:08PM
(#1449375)
Why is it only 3-4 times faster is what surprises me. No question that cutting out the PHP interpreter and VM is going to speed things up, but only ever so slightly?
[ Parent
| on HN ]
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib...
by ww520 on Monday June 21, 2010 @02:19PM
(#1449586)
The speed of MySQL is constant in both cases, and IO is always expensive, thus the CPU speedup via C vs PHP is not as dramatic as one hopes; remove MySQL from the equation and you'll see the gigantic difference.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib...
by piotrSikora on Monday June 21, 2010 @03:09PM
(#1449715)
Because it's taken out of the context. Original text says:
"We even observed that ngx_drizzle + ngx_rds_json achieved 128MB/sec (Yes, 1024Mbit/sec!) for a 380KB data-set query while connecting to a simple mysql server, about 3 ~ 4 times as fast as php + libmysql in this setting."
As you can imagine in such scenario (380KB result), MySQL engine is taking the most of the time.
Re:Nginx directly to mysql. 3 - 4 times as fast as php + lib...
by IgorPartola on Tuesday June 22, 2010 @11:21AM
(#1452115)
Good point. Every benchmark is only valid in the context in which it was taken.