← Back to Changelog

Prisma ORM v5.14.0: Prisma Optimize and createManyAndReturn

v5.14.0
May 15, 2024
Prisma ORMOptimize

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!

changelog-optimize.png

🎥 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.

Code export (1).png

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!