Performance of `auth.api.hasPermission` seem to be very slow

Do I need to create indexes in my sqlite database to improve it? [solved]

4 Replies

dD0K•5w ago

https://www.better-auth.com/docs/guides/optimizing-for-performance

Optimizing for Performance | Better Auth

A guide to optimizing your Better Auth application for performance.

thanks 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 auth.api.hasPermission call, it does reduce the time by 1/4 so there is some perf improvement which we can do.
Now I am only using auth.api.getSession which is slowest, My call look like const session = await auth.api.getSession({ headers: c.req.raw.headers }); I have configured cookie cache, but that is used on subseuqnt calls I guess.

  betterAuth({
    session: {
      cookieCache: {
        enabled: true,
        maxAge: 60 * 60 * 24 * 30, // 30 days
      }
    },

  betterAuth({
    session: {
      cookieCache: {
        enabled: true,
        maxAge: 60 * 60 * 24 * 30, // 30 days
      }
    },

My setup is - Cloudflare worker + D1 Sqlite + Drizzle ORM.

Nelson Sousa•4w ago

out of curiosity, how are you measuring the time it takes to query?

anand248OP•4w ago

  const startTime1 = performance.now();

// DB QUery, auth api call here.
  const endTime1 = performance.now();
console.info(`Time taken is : ${endTime1 - startTime1} milliseconds`);

  const startTime1 = performance.now();

// DB QUery, auth api call here.
  const endTime1 = performance.now();
console.info(`Time taken is : ${endTime1 - startTime1} milliseconds`);

But my problem is solved now. My D1 DB was hosted in far location. which I had to fix. Thanks for all the help.

Gaming

Programming

Performance of `auth.api.hasPermission` seem to be very slow

Did you find this page helpful?