One-to-one relationships in GraphQL - Time & Space Complexity
When working with one-to-one relationships in GraphQL, it's important to understand how the time to get data grows as the data size grows.
We want to know how the number of operations changes when we fetch related data for many items.
Analyze the time complexity of the following code snippet.
query GetUsersWithProfiles {
users {
id
name
profile {
id
bio
}
}
}
This query fetches a list of users and their related profile information, where each user has exactly one profile.
- Primary operation: Fetching each user and their single profile.
- How many times: Once for each user in the list.
As the number of users grows, the total work grows in a straight line.
| Input Size (n) | Approx. Operations |
|---|---|
| 10 | About 10 user-profile fetches |
| 100 | About 100 user-profile fetches |
| 1000 | About 1000 user-profile fetches |
Pattern observation: The work grows evenly as the number of users increases.
Time Complexity: O(n)
This means the time to get all users and their profiles grows directly with the number of users.
[X] Wrong: "Fetching one profile per user is constant time overall because each profile is just one item."
[OK] Correct: Even though each profile is one item, you still do this once for every user, so the total work grows with the number of users.
Understanding how fetching related data scales helps you explain data loading strategies clearly and confidently in real projects and interviews.
"What if each user had multiple profiles instead of one? How would the time complexity change?"