betterFetch response time is above 1s

Repo : https://github.com/laduniestu/better-next
Web : https://betternext.dun.gg

ORM Settings

ORM Settings

js const prisma =
    globalForPrisma.prisma ??
    new PrismaClient({
      log: ['query', 'info', 'warn', 'error'],
    });

js const prisma =
    globalForPrisma.prisma ??
    new PrismaClient({
      log: ['query', 'info', 'warn', 'error'],
    });

js const prisma =
    globalForPrisma.prisma ??
    new PrismaClient({
      log: ['query', 'info', 'warn', 'error'],
    });

js const prisma =
    globalForPrisma.prisma ??
    new PrismaClient({
      log: ['query', 'info', 'warn', 'error'],
    });

Auth Config

Auth Config

  session: {
    freshAge: 0,
    expiresIn: 60 * 60 * 24 * 3, 
    updateAge: 60 * 60 * 12, 
    cookieCache: {
      enabled: true,
      maxAge: 60 * 5, 
    },
  },

  session: {
    freshAge: 0,
    expiresIn: 60 * 60 * 24 * 3, 
    updateAge: 60 * 60 * 12, 
    cookieCache: {
      enabled: true,
      maxAge: 60 * 5, 
    },
  },

  session: {
    freshAge: 0,
    expiresIn: 60 * 60 * 24 * 3, 
    updateAge: 60 * 60 * 12, 
    cookieCache: {
      enabled: true,
      maxAge: 60 * 5, 
    },
  },

  session: {
    freshAge: 0,
    expiresIn: 60 * 60 * 24 * 3, 
    updateAge: 60 * 60 * 12, 
    cookieCache: {
      enabled: true,
      maxAge: 60 * 5, 
    },
  },

Middleware

Middleware

  const cookies = request.headers.get("cookie");
  const startTime = Date.now();
  const { data: session } = await betterFetch<Session>(
    "/api/auth/get-session",
    {
      baseURL: env.NEXT_PUBLIC_APP_URL,
      headers: {
        cookie: cookies || "",
      },
    }
  );
  const endTime = Date.now();
  const duration = endTime - startTime;
  console.log(`____Get Session Time: ${duration}ms`);
  console.log(cookies);

  const cookies = request.headers.get("cookie");
  const startTime = Date.now();
  const { data: session } = await betterFetch<Session>(
    "/api/auth/get-session",
    {
      baseURL: env.NEXT_PUBLIC_APP_URL,
      headers: {
        cookie: cookies || "",
      },
    }
  );
  const endTime = Date.now();
  const duration = endTime - startTime;
  console.log(`____Get Session Time: ${duration}ms`);
  console.log(cookies);

  const cookies = request.headers.get("cookie");
  const startTime = Date.now();
  const { data: session } = await betterFetch<Session>(
    "/api/auth/get-session",
    {
      baseURL: env.NEXT_PUBLIC_APP_URL,
      headers: {
        cookie: cookies || "",
      },
    }
  );
  const endTime = Date.now();
  const duration = endTime - startTime;
  console.log(`____Get Session Time: ${duration}ms`);
  console.log(cookies);

  const cookies = request.headers.get("cookie");
  const startTime = Date.now();
  const { data: session } = await betterFetch<Session>(
    "/api/auth/get-session",
    {
      baseURL: env.NEXT_PUBLIC_APP_URL,
      headers: {
        cookie: cookies || "",
      },
    }
  );
  const endTime = Date.now();
  const duration = endTime - startTime;
  console.log(`____Get Session Time: ${duration}ms`);
  console.log(cookies);

dunOP•12/19/24, 4:58 PM

Response when user visiting page without DB Interaction

Response when user visiting page without DB Interaction

2024-12-19T16:48:22.595998953Z ____Get Session Time: 1270ms
2024-12-19T16:48:22.596051502Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D
2024-12-19T16:48:22.626943844Z ____Get Session Time: 1304ms
2024-12-19T16:48:22.626989759Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D
2024-12-19T16:48:30.303781568Z ____Get Session Time: 2792ms
2024-12-19T16:48:30.303855556Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D

2024-12-19T16:48:22.595998953Z ____Get Session Time: 1270ms
2024-12-19T16:48:22.596051502Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D
2024-12-19T16:48:22.626943844Z ____Get Session Time: 1304ms
2024-12-19T16:48:22.626989759Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D
2024-12-19T16:48:30.303781568Z ____Get Session Time: 2792ms
2024-12-19T16:48:30.303855556Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D

Response when user visiting page with DB Interaction

Response when user visiting page with DB Interaction

2024-12-19T16:49:39.132026838Z ____Get Session Time: 1267ms
2024-12-19T16:49:39.132111045Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D
2024-12-19T16:49:39.147631149Z prisma:info Starting a postgresql pool with 9 connections.
2024-12-19T16:49:39.192945734Z prisma:query SELECT "public"."User"."_id", "public"."User"."name", "public"."User"."email", "public"."User"."emailVerified", "public"."User"."image", "public"."User"."createdAt", "public"."User"."updatedAt" FROM "public"."User" WHERE 1=1 OFFSET $1

2024-12-19T16:49:39.132026838Z ____Get Session Time: 1267ms
2024-12-19T16:49:39.132111045Z visited=1; __Secure-better-auth.session_token=LtYFFU1hM4DTxz6y0jGNYLHTZfu-Oi9q.h88ST47slFxrlaNQnAmXHQifk7MyzTLODUuIkZcFjoM%3D
2024-12-19T16:49:39.147631149Z prisma:info Starting a postgresql pool with 9 connections.
2024-12-19T16:49:39.192945734Z prisma:query SELECT "public"."User"."_id", "public"."User"."name", "public"."User"."email", "public"."User"."emailVerified", "public"."User"."image", "public"."User"."createdAt", "public"."User"."updatedAt" FROM "public"."User" WHERE 1=1 OFFSET $1

Ddun `Response when user visiting page without DB Interaction` ```bash 2024-12-19T16:...

bekacru•12/19/24, 5:01 PM

so bascially db being hit or not doesn't change the latency?

dunOP•12/19/24, 5:01 PM

yes

bekacru•12/19/24, 5:03 PM

what plugins are you using?

dunOP•12/19/24, 5:04 PM

  plugins: [openAPI()],

  plugins: [openAPI()],

Ddun `Response when user visiting page without DB Interaction` ```bash 2024-12-19T16:...

bekacru•12/19/24, 5:06 PM

yeah not sure what would cause this. I'll clone the repo and will try to see later.

dunOP•12/19/24, 5:07 PM

I really appreciate that, thank you. You're the best

Bbekacru yeah not sure what would cause this. I'll clone the repo and will try to see lat...

dunOP•12/19/24, 5:09 PM

wait, before you do that, could you please test those web first and is it the response time is the same as mine?

Original message was deleted

dunOP•12/19/24, 5:10 PM

dunOP•12/19/24, 5:10 PM

here is my average response time

dunOP•12/19/24, 8:58 PM

and i tried to remove it from my middleware, it become fast

dunOP•12/21/24, 5:44 PM

@bekacru any updates?

AAries Pretty absurd. https://files.aries.fyi/2024/12/19/859424a309051f28.png

bekacru•12/21/24, 8:42 PM

yours probably related to db indexing. the cli doesn't index fields

Ddun @bekacru any updates?

bekacru•12/21/24, 8:44 PM

I tried to take a look at the repo but couldn't pinpoint what is causing the issue. my current suggestions

make sure relevant fields are properly indexed
instead of fetching the session only check the existance of the cookie

Bbekacru I tried to take a look at the repo but couldn't pinpoint what is causing the iss...

dunOP•12/22/24, 1:06 AM

so, i just need to check the existance of the cookie? is it save to protect routes?

dunOP•12/22/24, 1:08 AM

like this?

const cookies = request.headers.get("cookie");

  if (isAuthRoute) { //login and signup
    if (!!cookies) {
      return NextResponse.redirect(new URL(AUTHENTICATED_URL, request.url));
    }
    return NextResponse.next();
  }

const cookies = request.headers.get("cookie");

  if (isAuthRoute) { //login and signup
    if (!!cookies) {
      return NextResponse.redirect(new URL(AUTHENTICATED_URL, request.url));
    }
    return NextResponse.next();
  }

AAries It's not & I didn't use the CLI.

bekacru•12/22/24, 6:53 AM

are you using remote db?

Ddun like this? ```js const cookies = request.headers.get("cookie"); if (isAuthRo...

bekacru•12/22/24, 6:53 AM

not only that but

const cookies = request.headers.get("cookie")
if(cookies.includes("session_token)){
  //
}

const cookies = request.headers.get("cookie")
if(cookies.includes("session_token)){
  //
}

Bbekacru yours probably related to db indexing. the cli doesn't index fields

Arthur•12/22/24, 8:13 AM

which fields do we need to index to improve perf ?

Bbekacru not only that but ```ts const cookies = request.headers.get("cookie") if(cooki...

dunOP•12/22/24, 3:35 PM

is it save? user can manipulate it right?

AArthur which fields do we need to index to improve perf ?

bekacru•12/22/24, 4:00 PM

token

token

in session table and

identifier

identifier

in verification table is good starting point. We're going to document this soon.

betterFetch response time is above 1s

Similar Threads

Similar Threads

Similar Threads