slow login and sign in times

E

EffeOP•6/3/25, 11:16 PM

@Ping

E

EffeOP•6/3/25, 11:19 PM

do you know? @Yup since you where able to help with a another question

I

iPheNoMeNaL-oG•6/3/25, 11:25 PM

It surely has to do with your database

I

iPheNoMeNaL-oG•6/3/25, 11:26 PM

why are you importing a bunch of different prisma clients

IiPheNoMeNaL-oG why are you importing a bunch of different prisma clients

E

EffeOP•6/3/25, 11:37 PM

im only importing it once

E

EffeOP•6/3/25, 11:37 PM

i have the other 3 times commented out

E

EffeOP•6/3/25, 11:37 PM

also @Yup i dont think it does cuz i was on postgres and then i changed to sqlite and its still slow

E

EffeOP•6/3/25, 11:38 PM

so is it just prisma since both was via prisma or is it my config

I

iPheNoMeNaL-oG•6/3/25, 11:41 PM

Um you cant just switch the key word and have it work the same

IiPheNoMeNaL-oG Um you *cant* just switch the key word and have it work the same

E

EffeOP•6/3/25, 11:42 PM

i changed it in prisma file too

E

EffeOP•6/3/25, 11:42 PM

not just the auth config

E

EffeOP•6/3/25, 11:45 PM

@Yup the time the sign in api endpoint took was about exactly the same from either db type

E

EffeOP•6/3/25, 11:45 PM

so im thinking its either my config or prisma being slow

I

iPheNoMeNaL-oG•6/3/25, 11:46 PM

It's defintely your config - prisma isn't slow

I

iPheNoMeNaL-oG•6/3/25, 11:46 PM

Well it shouldn't be

I

iPheNoMeNaL-oG•6/3/25, 11:46 PM

99% sure it's config

IiPheNoMeNaL-oG It's defintely your config - prisma isn't slow

E

EffeOP•6/3/25, 11:47 PM

i dont see what could be slowing it down in the config, i used prisma for all my other projects never had this issue

E

EffeOP•6/3/25, 11:47 PM

import { betterAuth } from "better-auth";
import { prismaAdapter } from "better-auth/adapters/prisma";
// import {PrismaClient} from '@moviebay/database'
import { username, admin } from "better-auth/plugins";
// import { PrismaClient } from '@prisma/client';
// const prisma = new PrismaClient();
import { PrismaClient } from '@moviebay/database';
const prisma = new PrismaClient();

export const auth = betterAuth({
  database: prismaAdapter(prisma, {
    provider: "sqlite",
  }),
    emailAndPassword: {
        enabled: true,
        autoSignIn: true,

    },

        advanced: {
            crossSubDomainCookies: {
                enabled: true,
                domains: ['my.moviebay.cc', 'beta.moviebay.cc', 'moviebay.cc']
            }
        },
        trustedOrigins: [
            '*.moviebay.cc'
        ]

  //... the rest of your config
});

// Export auth client creation function instead of creating it at module level
export { createAuthClient } from "better-auth/react";
export { usernameClient, adminClient } from 'better-auth/client/plugins';

import { betterAuth } from "better-auth";
import { prismaAdapter } from "better-auth/adapters/prisma";
// import {PrismaClient} from '@moviebay/database'
import { username, admin } from "better-auth/plugins";
// import { PrismaClient } from '@prisma/client';
// const prisma = new PrismaClient();
import { PrismaClient } from '@moviebay/database';
const prisma = new PrismaClient();

export const auth = betterAuth({
  database: prismaAdapter(prisma, {
    provider: "sqlite",
  }),
    emailAndPassword: {
        enabled: true,
        autoSignIn: true,

    },

        advanced: {
            crossSubDomainCookies: {
                enabled: true,
                domains: ['my.moviebay.cc', 'beta.moviebay.cc', 'moviebay.cc']
            }
        },
        trustedOrigins: [
            '*.moviebay.cc'
        ]

  //... the rest of your config
});

// Export auth client creation function instead of creating it at module level
export { createAuthClient } from "better-auth/react";
export { usernameClient, adminClient } from 'better-auth/client/plugins';

import { betterAuth } from "better-auth";
import { prismaAdapter } from "better-auth/adapters/prisma";
// import {PrismaClient} from '@moviebay/database'
import { username, admin } from "better-auth/plugins";
// import { PrismaClient } from '@prisma/client';
// const prisma = new PrismaClient();
import { PrismaClient } from '@moviebay/database';
const prisma = new PrismaClient();

export const auth = betterAuth({
  database: prismaAdapter(prisma, {
    provider: "sqlite",
  }),
    emailAndPassword: {
        enabled: true,
        autoSignIn: true,

    },

        advanced: {
            crossSubDomainCookies: {
                enabled: true,
                domains: ['my.moviebay.cc', 'beta.moviebay.cc', 'moviebay.cc']
            }
        },
        trustedOrigins: [
            '*.moviebay.cc'
        ]

  //... the rest of your config
});

// Export auth client creation function instead of creating it at module level
export { createAuthClient } from "better-auth/react";
export { usernameClient, adminClient } from 'better-auth/client/plugins';

import { betterAuth } from "better-auth";
import { prismaAdapter } from "better-auth/adapters/prisma";
// import {PrismaClient} from '@moviebay/database'
import { username, admin } from "better-auth/plugins";
// import { PrismaClient } from '@prisma/client';
// const prisma = new PrismaClient();
import { PrismaClient } from '@moviebay/database';
const prisma = new PrismaClient();

export const auth = betterAuth({
  database: prismaAdapter(prisma, {
    provider: "sqlite",
  }),
    emailAndPassword: {
        enabled: true,
        autoSignIn: true,

    },

        advanced: {
            crossSubDomainCookies: {
                enabled: true,
                domains: ['my.moviebay.cc', 'beta.moviebay.cc', 'moviebay.cc']
            }
        },
        trustedOrigins: [
            '*.moviebay.cc'
        ]

  //... the rest of your config
});

// Export auth client creation function instead of creating it at module level
export { createAuthClient } from "better-auth/react";
export { usernameClient, adminClient } from 'better-auth/client/plugins';

E

EffeOP•6/3/25, 11:47 PM

the config is pretty simple

E

EffeOP•6/3/25, 11:47 PM

not even a hook or anything

I

iPheNoMeNaL-oG•6/3/25, 11:48 PM

So prisma did update where the client is generated

I

iPheNoMeNaL-oG•6/3/25, 11:48 PM

https://www.prisma.io/docs/guides/nextjs#21-install-dependencies

How to use Prisma ORM and Prisma Postgres with Next.js 15 and Verce...

Learn how to use Prisma ORM in a Next.js app and deploy it to Vercel

IiPheNoMeNaL-oG https://www.prisma.io/docs/guides/nextjs#21-install-dependencies

E

EffeOP•6/3/25, 11:49 PM

i know it is working with prisma

E

EffeOP•6/3/25, 11:49 PM

oooh

E

EffeOP•6/3/25, 11:49 PM

i see something that i havent needed before

E

EffeOP•6/3/25, 11:49 PM

"@prisma/extension-accelerate"

E

EffeOP•6/3/25, 11:49 PM

thats new

E

EffeOP•6/3/25, 11:50 PM

i wonder if thats the issue

I

iPheNoMeNaL-oG•6/3/25, 11:50 PM

Can you show your sign-in flow/process?

IiPheNoMeNaL-oG Can you show your sign-in flow/process?

E

EffeOP•6/3/25, 11:50 PM

ye

E

EffeOP•6/3/25, 11:51 PM

@Yup btw in the example above i removed the username client to test if that was the issue but it wasnt so if you wonder why this sign in code uses username plugin thats why

E

EffeOP•6/3/25, 11:52 PM

    const handleSubmit = async (e: React.FormEvent) => {
        e.preventDefault()
        setIsLoading(true)
        setError("")

        try {
            console.log(formData.username)
            const { data, error } = await authClient.signIn.username({
                username: formData.username,
                password: formData.password,
            })

            if (error) {
                setError(error.message || "Failed to sign in")
            } else {
                router.push("/") // Redirect to home page
                router.refresh()
            }
        } catch (err) {
            setError("An unexpected error occurred")
        } finally {
            setIsLoading(false)
        }
    }

    const handleSubmit = async (e: React.FormEvent) => {
        e.preventDefault()
        setIsLoading(true)
        setError("")

        try {
            console.log(formData.username)
            const { data, error } = await authClient.signIn.username({
                username: formData.username,
                password: formData.password,
            })

            if (error) {
                setError(error.message || "Failed to sign in")
            } else {
                router.push("/") // Redirect to home page
                router.refresh()
            }
        } catch (err) {
            setError("An unexpected error occurred")
        } finally {
            setIsLoading(false)
        }
    }

    const handleSubmit = async (e: React.FormEvent) => {
        e.preventDefault()
        setIsLoading(true)
        setError("")

        try {
            console.log(formData.username)
            const { data, error } = await authClient.signIn.username({
                username: formData.username,
                password: formData.password,
            })

            if (error) {
                setError(error.message || "Failed to sign in")
            } else {
                router.push("/") // Redirect to home page
                router.refresh()
            }
        } catch (err) {
            setError("An unexpected error occurred")
        } finally {
            setIsLoading(false)
        }
    }

    const handleSubmit = async (e: React.FormEvent) => {
        e.preventDefault()
        setIsLoading(true)
        setError("")

        try {
            console.log(formData.username)
            const { data, error } = await authClient.signIn.username({
                username: formData.username,
                password: formData.password,
            })

            if (error) {
                setError(error.message || "Failed to sign in")
            } else {
                router.push("/") // Redirect to home page
                router.refresh()
            }
        } catch (err) {
            setError("An unexpected error occurred")
        } finally {
            setIsLoading(false)
        }
    }

E

EffeOP•6/3/25, 11:59 PM

@Yup im not sure why it doesnt work good, i checked the offical nextjs example and our configs look the same

I

iPheNoMeNaL-oG•6/4/25, 12:09 AM

hm this is strange, it should definitely not be taking as long as you say

IiPheNoMeNaL-oG hm this is strange, it should definitely not be taking as long as you say

E

EffeOP•6/4/25, 12:24 AM

Yeah up to 18000 ms

E

EffeOP•6/4/25, 12:24 AM

Which is really not normal

I

iPheNoMeNaL-oG•6/4/25, 12:31 AM

so you can we in network tab it takes 18000 ms to complete the sign in request?

IiPheNoMeNaL-oG so you can we in network tab it takes 18000 ms to complete the sign in request?

E

EffeOP•6/4/25, 1:24 AM

Yeah

E

EffeOP•6/5/25, 10:12 PM

@Yup @admin any update

EEffe @Yup @admin any update

H

Hexi•11/1/25, 2:10 PM

Have the same issue, 1214ms for just logging in

H

Hexi•11/1/25, 2:10 PM

Mind you its only 1 account in my prisma postgressql database

H

Hexi•11/1/25, 2:27 PM

Using bcrypt:

export const auth = betterAuth({
 emailAndPassword: {
    enabled: true,
    password: {
      hash: async (password: string) => {
        return await bcrypt.hash(password, 12)
      },
      verify: async ({ hash, password }) => {
        return await bcrypt.compare(password, hash)
      },
    },
  },
})

export const auth = betterAuth({
 emailAndPassword: {
    enabled: true,
    password: {
      hash: async (password: string) => {
        return await bcrypt.hash(password, 12)
      },
      verify: async ({ hash, password }) => {
        return await bcrypt.compare(password, hash)
      },
    },
  },
})

export const auth = betterAuth({
 emailAndPassword: {
    enabled: true,
    password: {
      hash: async (password: string) => {
        return await bcrypt.hash(password, 12)
      },
      verify: async ({ hash, password }) => {
        return await bcrypt.compare(password, hash)
      },
    },
  },
})

export const auth = betterAuth({
 emailAndPassword: {
    enabled: true,
    password: {
      hash: async (password: string) => {
        return await bcrypt.hash(password, 12)
      },
      verify: async ({ hash, password }) => {
        return await bcrypt.compare(password, hash)
      },
    },
  },
})

Seems to improve it by a lot

slow login and sign in times

Similar Threads

Similar Threads

Similar Threads