database-query-optimizer

Fix N+1 query problems by replacing inefficient loops of single database queries with optimized single queries using Prisma's `include` or `select` to fetch related data together. This prevents repeated database round trips and reduces query execution times.

Optimize slow database queries by identifying missing indexes on frequently filtered or sorted columns and reducing over-fetching. Adding composite indexes for common `where` clauses and selecting only necessary fields significantly improves query execution speed.

Prevent over-fetching data by selecting only the necessary fields and relations instead of retrieving entire records. Implementing `skip`/`take` or cursor-based pagination for list endpoints further limits the amount of unneeded data retrieved from the database.

Add composite indexes to your database when you have common `where` clauses filtering on multiple columns simultaneously. Indexing frequently filtered or sorted columns accelerates query execution and resolves performance bottlenecks in database interactions.

Query optimization does not break existing application behavior when applied correctly. The process utilizes Prisma best practices to enhance query efficiency while ensuring no existing functionality is disrupted during the performance improvements.

Implement pagination for database list endpoints by adding `skip` and `take` parameters or using cursor-based pagination. This restricts the number of records fetched, preventing over-fetching and reducing database load for large datasets.