When handling tens of thousands of requests, even small optimizations—like fine-tuning loops—can lead to impressive performance gains. #Cloudflare#Optimization
https://t.co/l8OA3dz5fm
Just wrote a small Golang package, #mlock, for managing concurrent access to a critical function. It ensures sequential execution within a group while remaining non-blocking for others.
https://t.co/Hv32LKWgjz
📦 Just released #ebolt, a Go package simplifying #bbolt key-value store operations with generic PUT, GET, DELETE methods, and expiration. Check it out on GitHub: https://t.co/djtd80w7gC
#bbolt#ebolt
Indexing random values(e.g. UUID) in a B+ tree brings challenges: 8KB page can only hold a small number of row references. Also while constant rebalancing due to no predetermined order leads to increased overhead #database#indexing
Column order in DB index matters! For example, an index ordered by C1, C2, and C3 can speed up a query with columns C2 and C1. However, if the query order is C2 and C3. it will go for a full table scan and slow down your query. #database#indexing
DB transactions can be tricky! Skipping commit/rollback after validation inside the transaction keeps the row-level lock unreleased, spiking open connections and leading to memory issues. #DBTransactions#OutOfMemory
Don't underestimate the power of thorough code review! Ignoring any part of your code could mean overlooking potential bugs hiding in plain sight. Take the time to review every line of code to ensure a stable and reliable product. #codereview#bugdetection