News for hackers. Stuff that matters.
Re:Web API performance: profiling Django REST framework. by bhauer on Friday July 12, 2013 @12:32PM (#6033501)
His measurement is around this line:

    users = list(User.objects.all())
That will include Postgres' work, the Python Postgres driver's work, and the ORM's work. Elsewhere, we've already seen that Postgres and MySQL can provide a response to such a trivial query over Ethernet in less than 5ms, under heavy concurrent load, on commodity hardware. But his measurement is 90ms.

For the sake of argument, let's say that hardware variations mean his local Postgres instance (that is, an instance without Ethernet latency to contend with) requires 20ms to fulfill the query. Maybe his laptop is from 2006. That still leaves 70ms unaccounted for.

It's not Postgres' fault.

Re:Web API performance: profiling Django REST framework. by ijl on Friday July 12, 2013 @01:40PM (#6033879)
In the article it's actually 9ms rather than 90ms--0.009 seconds.
Re:Web API performance: profiling Django REST framework. by bhauer on Friday July 12, 2013 @04:51PM (#6035105)
Oh! Thanks for pointing that out. That means the numbers are more in line with what I've seen elsewhere. Sorry for the tangent!