Slow API

PIat · 2025-01-23T21:55:50.171Z

Hello! When I try try create an organization and update it immediately, the update either doesn't run at all or it takes about 20 seconds. What is the reason for this slowdown?

P

PIatOP•1/24/25, 12:49 PM

An example

const org = await auth.api.createOrganization({
        headers,
        body: {
            name: tempOrgId,
            slug: tempOrgId,
        },
    })


await auth.api.updateOrganization({
                            headers: request.headers,
                            body: {
                                data: {
                                    name: orgId,
                                    slug: orgId,
                                },
                            },
                        })

const org = await auth.api.createOrganization({
        headers,
        body: {
            name: tempOrgId,
            slug: tempOrgId,
        },
    })


await auth.api.updateOrganization({
                            headers: request.headers,
                            body: {
                                data: {
                                    name: orgId,
                                    slug: orgId,
                                },
                            },
                        })

const org = await auth.api.createOrganization({
        headers,
        body: {
            name: tempOrgId,
            slug: tempOrgId,
        },
    })


await auth.api.updateOrganization({
                            headers: request.headers,
                            body: {
                                data: {
                                    name: orgId,
                                    slug: orgId,
                                },
                            },
                        })

const org = await auth.api.createOrganization({
        headers,
        body: {
            name: tempOrgId,
            slug: tempOrgId,
        },
    })


await auth.api.updateOrganization({
                            headers: request.headers,
                            body: {
                                data: {
                                    name: orgId,
                                    slug: orgId,
                                },
                            },
                        })

P

PIatOP•1/28/25, 6:17 PM

Bump

PPIat An example ```ts const org = await auth.api.createOrganization({ headers...

B

bekacru•1/28/25, 6:43 PM

you should check if there are any problem with your db connection. all the api does is just call insert to db

P

PIatOP•1/28/25, 6:45 PM

Thank you for the answer! I also expected it to be the case, but this doesn't happen anywhere in my postgres connection outside of this usecase. But if you say the library doesn't introduce additional rate limits, it must be the case

PPIat Thank you for the answer! I also expected it to be the case, but this doesn't ha...

B

bekacru•1/28/25, 6:57 PM

all the library does is just insert those data to your database. What adapter are you using?

P

PIatOP•1/28/25, 6:58 PM

The Prisma adapter

prismaAdapter(prisma, {
  provider: 'postgresql',
}),

prismaAdapter(prisma, {
  provider: 'postgresql',
}),

prismaAdapter(prisma, {
  provider: 'postgresql',
}),

prismaAdapter(prisma, {
  provider: 'postgresql',
}),

PPIat An example ```ts const org = await auth.api.createOrganization({ headers...

P

PIatOP•1/28/25, 6:59 PM

These manipulations are taking place in an interactive transaction

prisma.$transaction

prisma.$transaction

prisma.$transaction

prisma.$transaction

PPIat An example ```ts const org = await auth.api.createOrganization({ headers...

P

PIatOP•1/31/25, 8:18 PM

I can confirm no slowdowns are happening anywhere else in the database. Even running dozens of queries a second doesn't introduce any noticeable delay, only this part

P

PIatOP•2/2/25, 10:27 AM

It could be a red herring and the problem could actually be with the

getSession

getSession

function being slow on my end, since having it in the first place slows things down dramatically

P

PIatOP•2/2/25, 10:37 AM

It's very illogical that it would be slow, but it's what I'm seeing. Without the introduction of better-auth client the app works as it should.

After making a few request, the app hangs

RRakesh is ur code open source?

P

PIatOP•2/2/25, 10:45 AM

Unfortunately not

PPIat Unfortunately not 🫠

B

bekacru•2/2/25, 10:48 AM

also make sure to index the

token

token

token

token field in your session table

Similar Threads

Similar Threads

Similar Threads