Hacker News new | ask | show | jobs
by bravura 1191 days ago
If you code a website, your speed issues probably come from the database layer. Not your Python.
1 comments

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.

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.