hey yall!
where can i read about using indexes in conjunction with Prisma?
Is it possible to optimize deeply nested Prisma queries using indexes?
I'm using MySQL btw
👋🏾 1
👋 1
r
Ryan
06/29/2021, 5:21 AM
@Spencer Curry 👋
You should be able to add indexes via Prisma Migrate in the generated
.sql
files. Then querying with the correct filters should automatically use those indexes.
j
janpio
06/29/2021, 1:10 PM
There is no deep control about the indexes used - usually the DBMS is quite good about that.
janpio
06/29/2021, 1:11 PM
If you have a specific use case, please open an issue and we can think how we could integrate that in Prisma.
janpio
06/29/2021, 1:11 PM
As far as I know there is no issue like that yet, so there does not seem to be much demand for it in general.