• dan@upvote.au
    link
    fedilink
    arrow-up
    1
    ·
    3 months ago

    A single click in the software can often generate 500 SQL queries, so if you go from 0.05 ms to 1 ms latency you add half a second to clicks

    Those queries don’t all have to be executed sequentially though, do they? Usually if you have that many queries, at least some of them are completely independent of the others and thus can execute concurrently.

    You don’t even need threading for that, just non-blocking IO and ideally an event loop.