marcoklein / impromat

The Improvisational Theatre App
https://impromat.app
GNU General Public License v3.0
5 stars 0 forks source link

[Technical Feature] Optimize Prisma Queries to leverage data loader #397

Open marcoklein opened 6 months ago

marcoklein commented 6 months ago

Is your feature request related to a problem? Please describe. Some database queries are slower and prone to the n+1 loading problem due to the Graphql API. E.g. multiple queries are unnecessarily sent to the database.

Describe the solution you'd like Apply query optimization as described by the Prisma documention here

Describe alternatives you've considered Since we are using Prisma we have to optimize Prisma. An alternative would also be to use a more general dataloader.

Additional context