Marketplace queries filter resaleListing rows by status (active listings, status updates by { ticketId, status }), but status has no @@index on the ResaleListing model. As listings grow this becomes a full-table scan on every marketplace page load.
Suggested fix: Add @@index([status]) to the ResaleListing model in prisma/schema.prisma.
Marketplace queries filter
resaleListingrows bystatus(active listings, status updates by{ ticketId, status }), butstatushas no@@indexon theResaleListingmodel. As listings grow this becomes a full-table scan on every marketplace page load.Suggested fix: Add
@@index([status])to theResaleListingmodel inprisma/schema.prisma.