Prisma is 100x slower than "better-sqlite"

[Mwni]

Bug description

Running the same query, for example a simple INSERT, takes about 1ms with prisma, and 0.01ms with better-sqlite.
Is this a known issue or is there something wrong with my setup?

How to reproduce

https://github.com/Mwni/prisma-vs-better-sqlite

Environment & setup

• OS: Darwin & Windows
• Database: SQLite
• Node.js version: 16.2

Prisma Version

prisma                  : 3.12.0
@prisma/client          : 3.12.0
Current platform        : darwin
Query Engine (Node-API) : libquery-engine 22b822189f46ef0dc5c5b503368d1bee01213980 (at node_modules/@prisma/engines/libquery_engine-darwin.dylib.node)
Migration Engine        : migration-engine-cli 22b822189f46ef0dc5c5b503368d1bee01213980 (at node_modules/@prisma/engines/migration-engine-darwin)
Introspection Engine    : introspection-core 22b822189f46ef0dc5c5b503368d1bee01213980 (at node_modules/@prisma/engines/introspection-engine-darwin)
Format Binary           : prisma-fmt 22b822189f46ef0dc5c5b503368d1bee01213980 (at node_modules/@prisma/engines/prisma-fmt-darwin)
Default Engines Hash    : 22b822189f46ef0dc5c5b503368d1bee01213980
Studio                  : 0.459.0

[Mwni]

I was able to trace the origin down to the binary query engine. It makes up about 80% of the query time. From there on it's getting harder to profile this...

[andykais]

If I had to guess, this probably has to do with a lack of query caching....but if I had to guess further, I would be very confused why thats an issue either, since most sqlite driver libraries have a caching layer below prepared statements

[janpio]

Probably related: #3303