What are common performance issues when integrating a database with Next.js, and how do you fix them?

Common issues include running the same query multiple times unnecessarily due to missing request deduplication, fetching more data than a page actually needs, and not adding proper database indexes for frequently queried fields, all of which can be fixed by combining efficient queries with Next.js caching features.

// Only select the fields actually needed
const posts = await db.post.findMany({
  select: { id: true, title: true },
  take: 10
});