Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feat: use dummy instance id to improve performance on refresh token queries #1454

Merged
merged 1 commit into from
Mar 4, 2024

Conversation

J0
Copy link
Contributor

@J0 J0 commented Feb 26, 2024

What kind of change does this PR introduce?

Use the nil instance ID so that we can leverage the compound index on instance_id and user_id when performing search and deletion

Aims to address #1449 and #1398.

We note that LogoutAllRefreshTokens was marked as deprecated and may be possible to remove if all access tokens now have a sessionId. Additionally, FindTokenBySessionID can likely be replaced by using FindCurrentlyActiveRefreshToken.

We will revisit these in a week or two but they are out of scope for this PR.

@J0 J0 changed the title feat: use add dummy instance id so we can use the compound index feat: use dummy instance id so we can use the compound index on refresh tokens table Feb 26, 2024
@J0 J0 changed the title feat: use dummy instance id so we can use the compound index on refresh tokens table feat: use dummy instance id to improve performance on refresh token queries Mar 3, 2024
@J0 J0 force-pushed the j0/use_index_on_refresh_token branch from 0248a62 to 7c750fd Compare March 3, 2024 16:46
@J0 J0 marked this pull request as ready for review March 3, 2024 16:57
@J0 J0 requested a review from a team as a code owner March 3, 2024 16:57
@J0 J0 merged commit 656474e into master Mar 4, 2024
10 checks passed
@J0 J0 deleted the j0/use_index_on_refresh_token branch March 4, 2024 04:05
hf pushed a commit that referenced this pull request Mar 5, 2024
🤖 I have created a release *beep* *boop*
---


##
[2.144.0](v2.143.0...v2.144.0)
(2024-03-04)


### Features

* add configuration for custom sms sender hook
([#1428](#1428))
([1ea56b6](1ea56b6))
* anonymous sign-ins
([#1460](#1460))
([130df16](130df16))
* clean up test setup in MFA tests
([#1452](#1452))
([7185af8](7185af8))
* pass transaction to `invokeHook`, fixing pool exhaustion
([#1465](#1465))
([b536d36](b536d36))
* refactor resource owner password grant
([#1443](#1443))
([e63ad6f](e63ad6f))
* use dummy instance id to improve performance on refresh token queries
([#1454](#1454))
([656474e](656474e))


### Bug Fixes

* expose `provider` under `amr` in access token
([#1456](#1456))
([e9f38e7](e9f38e7))
* improve MFA QR Code resilience so as to support providers like
1Password ([#1455](#1455))
([6522780](6522780))
* refactor request params to use generics
([#1464](#1464))
([e1cdf5c](e1cdf5c))
* revert refactor resource owner password grant
([#1466](#1466))
([fa21244](fa21244))
* update file name so migration to Drop IP Address is applied
([#1447](#1447))
([f29e89d](f29e89d))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

Co-authored-by: github-actions[bot] <41898282+github-actions[bot]@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

2 participants