graphql-python / graphql-python/graphene-sqlalchemy

Performance Issue: Inefficient Slicing of Connection Queries

Open
#423 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
985
Forks
223
PR merge metrics
No merged PRs in 30d

Description

Performance Issue: Inefficient Slicing of Connection Queries

Currently, when performing a connection query with arguments like first: 20, after: some_token, the system retrieves the entire dataset from the database and then applies slicing in-memory. This approach becomes increasingly inefficient as the size of the database grows.

It would be highly beneficial to support slicing directly at the database level to improve performance and reduce unnecessary data processing.

Suggested Improvement:
Implement database-level pagination to handle first, after, etc., during the query execution phase, rather than after data retrieval.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.