Elektrine lite

← Feed

@futzle@old.mermaid.town

2026-09-21 03:44 UTC

Always a joy* to see which important foreign keys the creator of this database figured didn't need to be indexed. Query that should take seconds is timing out after ten minutes because I had the temerity to join two tables.

Replies (2)

  • @nivex@tenforward.social 2026-09-21 03:49

    @futzle@old.mermaid.town This is all too familiar. At a previous job we had outsourced development of an application and they were keeping one of the backend admin interfaces to themselves. We raised enough of a fuss and they "graciously" sent the module over. We stood it up on our infra and just logging in took 30 seconds. One of our devs took a look at it, made a lot of grumbling noises, added one index, and logins were instantaneous after that.

    Open ##5150416

  • @pilum@fedi.j1nk4l.com 2026-09-21 05:52

    @futzle@old.mermaid.town I've seen a lot of travesties caused by people who have no understanding of databases whatsoever designing systems with database backends. The guy who had a single table with a single column containing a single row which contained a ginornous XML data structure is hard to beat though.

    Open ##5150419