Hacker News new | ask | show | jobs
by FridgeSeal 1186 days ago
What are you doing to your database? Lol

Most databases I’ve dealt with will happily outstrip Python for a good chunk of the common queries.

2 comments

Measuring database speed is ultimately I/O bound, measuring a language's speed is typically CPU-bound.
For sure, but django for instance is really good at turning something that ought to be one query into N+1 queries.
how do you deal with this?
In my experience? optimize things once it turns out to be a problem. It's not easy though and one of the many reasons I don't love the django ORM.
Don't abuse the damn ORM.

And write SQL directly for medium complexity queries.