This repository was archived by the owner on Mar 21, 2025. It is now read-only.
Repository navigation
Replies: 2 comments 1 reply
|
We've ran some benchmarks for compile time, but not really any for runtime. I can confidently say though that PCR will likely not be as fast as other ORMS, especially raw SQL. The Prisma engines do a loooot of work behind the scenes that other ORMs don't. |
1 reply
|
@Brendonovich I've made a very very simple benchmark. It could probably use some work and would love your input on it! https://github.com/hariria/rust-orm-bench. TLDR from running it: # Each of the Create / Find / Delete benchmarks below
# were based on 10,000 records being added, found, or deleted
# to a SQLITE DB serially, without any kind of concurrency
# Each record was related to a user, with a GUID as its PK
# and ID. For more info see the prisma/schema.prisma file
Running diesel benchmarks...
Create users elapsed 4.08s
Find users elapsed 108.22ms
Delete users elapsed 4.21s
Running prisma benchmarks...
Create users elapsed 8.42s
Find users elapsed 2.37s
Delete users elapsed 7.63s
Running prisma raw sql benchmarks...
Create users elapsed 4.28s
Find users elapsed 1.35s
Delete users elapsed 4.20sMost notably it seems like read performance for Diesel is much closer to the read performance limits of sqlite (~100k reads / second) and for some reason prisma was 20x slower. I tried using |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Hey I was curious if there were any performance benchmarks done on this vs. other competitors like Diesel / SeaORM etc. vs raw sql. Thanks!
All reactions