Python-based compiler achieves orders-of-magnitude speedups

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 ]