Search: "database-tuning"

78 prompts matching "database-tuning"

"database-tuning" ✕ Clear all ✕

coding Intermediate

Review code like you actually have to maintain it next year

Review the code below as if you'll be the one maintaining it in twelve months. D...

#coding #code review #maintainability

coding Advanced

Pick the right caching layer when every option looks reasonable on paper

Act as a staff engineer who has lived with these decisions. I need to add cachin...

#caching #architecture #redis

data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#data #sql #query-optimization

coding Advanced

Coding: Write the SQL Index I Actually Need (Not the One I Think I Need)

I have a slow query and I'm about to add an index. Before I do, help me think it...

#coding #sql #performance

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill

coding Advanced

Optimize a Slow Database Query

Act as a database performance engineer. Here is a slow query and its context: [P...

#coding #database #performance