News for hackers. Stuff that matters.

A comment on Python-based compiler achieves orders-of-magnitude speedups. Parent comment

Re:Python-based compiler achieves orders-of-magnitude speedups by BiteCode_dev on Wednesday March 15, 2023 @01:22PM (#35171674)
Depends of the work you have to do.

If you code a website, fast api and django, the two most popular framework to do so, heavily rely on them to make you productive.

[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by bravura on Wednesday March 15, 2023 @01:51PM (#35172109)
If you code a website, your speed issues probably come from the database layer. Not your Python.
[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by FridgeSeal on Wednesday March 15, 2023 @05:17PM (#35174840)
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.

[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by DougMerritt on Wednesday March 15, 2023 @05:32PM (#35175021)
Measuring database speed is ultimately I/O bound, measuring a language's speed is typically CPU-bound.
[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by Doxin on Thursday March 16, 2023 @04:26AM (#35179533)
For sure, but django for instance is really good at turning something that ought to be one query into N+1 queries.
[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by fud101 on Thursday March 16, 2023 @08:48AM (#35181168)
how do you deal with this?
[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by WhatTheFlak on Thursday March 16, 2023 @08:08PM (#35190798)
Don't abuse the damn ORM.

And write SQL directly for medium complexity queries.

[ Parent | on HN ]
Re:Python-based compiler achieves orders-of-magnitude speedups by Doxin on Friday March 17, 2023 @10:09AM (#35197287)
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.
[ Parent | on HN ]