CodeBucks⚡ (@code_bucks) 's Twitter Profile
CodeBucks⚡

@code_bucks

🚀 Web Developer & AI Innovator
🎯 35k+ YouTube Subs
🤖 Passionate about Generative AI
🏗️ Building an AI Agents
📩 DM for Web & AI Solutions

ID: 1302187537629413376

linkhttps://linktr.ee/codebucks calendar_today05-09-2020 10:11:31

814 Tweet

461 Followers

374 Following

CodeBucks⚡ (@code_bucks) 's Twitter Profile Photo

Your database is slow? Try these 4 fixes first (before adding more servers): 1️⃣Add indexes on columns you query frequently 2️⃣Limit SELECT queries, don't SELECT * instead specify columns 3️⃣Use EXPLAIN to see query execution plan 4️⃣Paginate results, never return more than 100

Your database is slow? 

Try these 4 fixes first (before adding more servers):

1️⃣Add indexes on columns you query frequently
2️⃣Limit SELECT queries,  don't SELECT * instead specify columns
3️⃣Use EXPLAIN to see query execution plan
4️⃣Paginate results, never return more than 100