[brucethemoose2]

I dont necessarily need all that dynamism though, and would happily use a Python subset that removed some stuff (and forced type hinting) in exchange for better compilation.

Yes there are already subsets like this, but its not as helpful if it isnt standard.

[BiteCode_dev]

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.

[bravura]

If you code a website, your speed issues probably come from the database layer. Not your Python.

[FridgeSeal]

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.

[DougMerritt]

Measuring database speed is ultimately I/O bound, measuring a language's speed is typically CPU-bound.

[Doxin]

For sure, but django for instance is really good at turning something that ought to be one query into N+1 queries.

[fud101]

how do you deal with this?

[Doxin]

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.

[WhatTheFlak]

Don't abuse the damn ORM.

And write SQL directly for medium complexity queries.

[echelon]

Starlark comes to mind, but that's probably too limited.