I just optimized a query from 1.5ms to 0.5ms on a page that has several queries in the 10ms range.
@ayo your queries are fast
@wolf480pl your queries aren't?
@ayo "my" queries (generated by ORM based on code written by clueless students) take seconds.
@ayo well ok, not seconds, more like a few hundred ms, but still.
@ayo actually it's just one of two queries, the rest are fine.
I had a WIP refactor of the permission code that would make the most offending query orders of magnitude faster, should finish that one day.
A lonely little town in the wider world of the fediverse.