Optimize SQL Queries for Token and Client Management - Githubissues

Mehrn0ush / RustifyAuth

"Rustify-Auth is a lightweight OAuth 2.0 & 2.1 authorization server in Rust, designed with educational goals in mind. It supports Authorization Code + PKCE, Client Credentials, Refresh Tokens, secure JWT token generation, and Post-Quantum Cryptography (PQC) for enhanced future-proof security.

MIT License

8 stars 4 forks source link

Optimize SQL Queries for Token and Client Management #12

Open Mehrn0ush opened 1 month ago

Mehrn0ush commented 1 month ago

Description: After implementing the SQL and PostgreSQL storage backends, we need to optimize the SQL queries used for token management and client data retrieval to ensure high performance. This is critical for ensuring that rustify-auth can scale efficiently when using SQL databases.

Requirements:

Analyze the SQL queries for token storage, validation, and revocation, as well as client CRUD operations.
Optimize query performance, particularly for high-traffic OAuth2 operations like token validation and introspection.
Ensure that indexes are added where necessary to improve query performance.

Tasks:

[ ] Profile SQL queries used for token and client management.
[ ] Add appropriate indexes to speed up query performance.
[ ] Optimize SELECT, INSERT, and DELETE queries to ensure fast token validation and revocation.
[ ] Write performance benchmarks to measure query speed before and after optimization.

github-actions[bot] commented 14 hours ago

This issue has been marked as stale due to inactivity. It will be closed if no further activity occurs.