Back to Homepage

One-to-Many Relationship Benchmark

This report analyzes a more advanced, real-world scenario: the performance of handling database relationships. This test measures the efficiency of creating and retrieving records that involve a database join.

Results Explorer

Test Scenario

View Data From

The chart below compares framework performance across all three runs. Use the controls above to explore detailed metrics and analysis for a specific run.

Key Metrics:

Contextual Analysis for

Test Methodology

Test Scenario

  • Models: Author (One) & Article (Many)
  • Create: POST new articles linked to one of 50 random authors.
  • List/Read: GET requests that require a database join to include author data.

Environment

  • OS: Lubuntu 24.04.3 (in Oracle VM)
  • Python: 3.12 (Virtual Environment)
  • Database: SQLite

Benchmarking Tool

  • Tool: wrk HTTP benchmark
  • Duration: 10 seconds per test
  • Concurrency: 100 connections on 2 threads

Conclusion

Even in a more demanding scenario that requires handling database relationships, Jetio maintains a significant performance lead across multiple runs. Its ability to efficiently eager-load related data with a simple `load_relationships` flag proves that the framework's focus on developer experience does not come at the cost of performance. Jetio is a robust and highly efficient choice for building complex, real-world APIs.