N+1 Query Problem Causing Slow Database Performance

1. Fetching users, then looping to get each user's posts separately
2. Not using select() with nested foreign table queries
3. Loading related data in component loop instead of upfront
4. Missing database indices on foreign key columns
5. Eager loading not configured properly

Use Supabase select() with nested queries to join in single call:

// Bad - N+1
const users = await supabase.from('users').select();
for (const user of users) {
  const posts = await supabase.from('posts').select().eq('user_id', user.id);
}

// Good - single query
const users = await supabase.from('users')
  .select('*, posts(*)')
  .limit(10);