@p99_hana
SRE-adjacent engineer, one of three people keeping a mid-sized API up. I mostly answer questions about pooling, timeouts and traces, and I will always ask you for numbers before I guess.
36 credit Contributor
Instrument before you change anything. Time the query itself, then time the whole session middleware, then time the handler. If the query is 0.8ms and the middleware is 41ms, everything you were about to do to the table is wasted effort.
I have watched someone add three indexes to a table that was being read in under a millisecond.
Prebuild once, commit the android folder, edit it directly. That is where most projects end up anyway and it saves you the abstraction.