PrismaP
Prisma14mo ago
21 replies
schettn

Prisma Studio crashes with large databases

I have the following model:

model GTFSImport {
  id   Int      @id @default(autoincrement())
  date DateTime

  trafficRegions TrafficRegion[]
  tourismRegions TourismRegion[]

  agencies     Agency[]
  calendars    Calendar[]
  routes       Route[]
  stops        Stop[]
  trips        Trip[]
  stopTimes    StopTime[]
  CalendarDate CalendarDate[]
}


When i try to view this model in Prisma studio, the tab crashes. The GTFSImport label has only 1 row.
The issue is that all of the relations of this row combined return about 1M records.

It seems like Prisma Studio fetches all relations just to display the relation count in the UI.

Although Prisma Studio uses pagination (Only the first 100) in the model you view, it fetches all relations, making the pagination useless.


Related: https://github.com/prisma/studio/issues/1260
image.png
GitHub
Bug description When prisma studio spins up, it defaults to fetching all of the relations in order to show a count in the UI. This causes it to hit Planetscale's row read limit of 100,000 in a ...
Was this page helpful?