Prisma ORM v5.14.0: Prisma Optimize and createManyAndReturn
Prisma ORM v5.14.0: Prisma Optimize and createManyAndReturn
Ever wondered what SQL the Prisma ORM generates under the hood? Want to understand the performance of your app and deliver a better and faster experience for your users? With Prisma Optimize you can!

🎥 Watch our video walkthrough using dub.co as a case study.
Read the announcement blog post for instructions on how to get started and optimize your own application.
Introducing new Prisma client query: createManyAndReturn()
In our 5.14.0 release, we made available a new, top-level Prisma Client query: createManyAndReturn(). It works similarly to createMany() but uses a RETURNING clause in the SQL query to retrieve the records that were just created.
Here’s an example of creating multiple posts and then immediately returning those posts.

Read more in our release notes
MongoDB performance improvements
Previously, Prisma ORM suffered from performance issues when using the in operator or when including related models in queries against a MongoDB database.
With 5.14.0, Prisma ORM now rewrites queries to use a combination of $or and $eq operators, leading to dramatic performance increases for queries that include in operators or relation loading.
See the closed public issues in our release notes.
Prisma ORM Benchmark
Curious to see how Prisma ORM performs with popular DB providers?
We’ve worked with Vercel to add ORMs to their open-source database latency benchmarks.
🚀 Run the test and see for yourself!
Documentation Updates
Explore Pulse’s features and use cases in our updated documentation and follow our get-started guide to set up Pulse in minutes.
In our Platform docs, we’ve refined the descriptions of Workspaces, Projects, and Environments and our billing information to make managing your projects and understanding your costs even easier.
Introducing our Build, Fortify, Grow Framework
Learn how Prisma products interoperate at each stage to enhance your data-driven application development process.
👉 Read up on the Prisma BFG framework
Discord is where it’s at! 🤖
As of 1 May 2024, we've transitioned from our community Slack to our Discord server. Join us over there to showcase your projects, get community support, or simply meet & chat with your fellow devs.
See you on Discord!