I'm using Prisma with Neon DB (free tier). I have a waitlist feature where I count the number of signups using prisma.waitlist.count(). Locally, it returns 50 (in DB there are 50 fields), but in production, it returns 36.

This is the route.js for count-api:

import { NextResponse } from "next/server";
import { prisma } from "../../../../utils/prisma";

export async function GET() {
  try {
    const count = await prisma.waitlist.count();
    return NextResponse.json({ count }, { status: 200 });
  } catch (error) {
    return NextResponse.json(
      { message: "Error fetching count" },
      { status: 500 }
    );
  }
}