Offset pagination performance limits in Prisma at scale
Prisma's `findMany` maps `skip` and `take` to SQL `OFFSET` and `LIMIT`, enabling offset-based pagination without extra configuration. The research brief notes that offset pagination performance degrades linearly with offset size, but the practical threshold at which this becomes problematic varies with table size, index coverage, and concurrent mutation rate
prisma