Performance of `auth.api.hasPermission` seem to be very slow
Do I need to create indexes in my sqlite database to improve it? [solved]
DA guide to optimizing your Better Auth application for performance.
Athanks for above. I did applied index, but still the issue (absence of indexes should not be the problem since I don't have much data anyway).
When I query the db myself, instead of using call, it does reduce the time by 1/4 so there is some perf improvement which we can do.
Now I am only using which is slowest, My call look like
I have configured cookie cache, but that is used on subseuqnt calls I guess.
My setup is - Cloudflare worker + D1 Sqlite + Drizzle ORM.
When I query the db myself, instead of using call, it does reduce the time by 1/4 so there is some perf improvement which we can do.
Now I am only using which is slowest, My call look like
I have configured cookie cache, but that is used on subseuqnt calls I guess.
My setup is - Cloudflare worker + D1 Sqlite + Drizzle ORM.
Nout of curiosity, how are you measuring the time it takes to query?
ABut my problem is solved now. My D1 DB was hosted in far location. which I had to fix. Thanks for all the help.