TechEmpower.FrameworkBenchmarks/frameworks/Python/aiohttp

aiohttp Benchmark Test

The information below is specific to aiohttp. For further guidance, review the documentation. Also note that there is additional information that's provided in the Python README.

This is the Python aiohttp portion of a benchmarking tests suite comparing a variety of frameworks.

All test implementations are located within (./app).

Description

aiohttp with sqlalchemy and separately asyncpg for database access.

uvloop is used for a more performant event loop.

Database

PostgreSQL.

Two variants:

• ORM using sqlalchemy
• RAW using asyncpg

To enabled "RAW" mode set the following environment variable:

export CONNECTION=RAW

This will switch which database engine the app uses to execute queries with tests 2, 3, 4 & 5.

Server

nginx+uvloop on CPython

Test URLs

Test 1: JSON Encoding

http://localhost:8080/json

Test 2: Single Row Query

http://localhost:8080/db

Test 3: Multi Row Query

http://localhost:8080/queries/20

Test 4: Fortunes (Template rendering)

http://localhost:8080/fortunes

Test 5: Update Query

http://localhost:8080/updates/20

Test 6: Plaintext

http://localhost:8080/plaintext