Improve /logout speed

[thorwebdev]

Chore

Describe the chore

The supabase.auth.logout() function takes consistently more than 2 seconds to resolve. Is there anything we can do to speed this up? It's a bit awkward for that much delay after hitting the signout button.

Additional context

Tested here: https://nextjs-subscription-payments-starter.vercel.app/

[icecream78]

Somewhy mysql doesn't use index while logout.

I'll try figure out how to tune perfomance of this query, but I'm not PRO in stuff like this and will take some time=)

[J0]

Should be resolved by the move to sessions and the change in the underlying query to make use of the sessions model rather than refresh tokens. Going to close for now but feel free to re-open if issue persists.

cc: @kangmingtay @hf

Realized after posting that a tag wasn't quite needed(bc there's no follow up action required) -- please ignore