CYBERSECURITY
FEATURED ANALYSIS
Hash Indexes in Prisma ORM: Fast Equality Lookups in Postgres
SOURCE
Prisma Blog
DATE
READ
1 min read
Add a hash index in Prisma with @@index(type: Hash): a 64ms sequential scan becomes a 1.6ms lookup, verified on Prisma ORM 7 and PostgreSQL 17.
Add a hash index in Prisma with @@index(type: Hash): a 64ms sequential scan becomes a 1.6ms lookup, verified on Prisma ORM 7 and PostgreSQL 17.