PHP Benchmarking Test

This is the PHP portion of a benchmarking test suite comparing a variety of web development platforms.

Important

When editing this framework, be sure to force add the files changed. Most files were added to .gitignore, as the framework touches some of them during testing.

Infrastructure Software Versions

The tests were run with PHP Version 7.3.* + OPcache

Platforms

• php-fpm 7.4.*
• nginx unit 1.18.0 (PHP 7.4)

Webservers

• nginx 1.17.10
• h2o 2.2.6

Databases

• MySQL 8
• PostgreSQL 12

ActiveRecord

• PHP ActiveRecord Nightly 20121221

Eloquent ORM / Laravel Query Builder

• illuminate/database 5.8

The Laravel query builder / eloquent ORM components can be run separately from the Laravel framework. (Instructions) This is used for two tests:

• php-laravel-query-builder: uses the Laravel query builder without using the full Eloquent ORM.
  This tests the overhead of the dependency injection container (Capsule) and the query builder without the overhead of the Eloquent ORM models.
• php-eloquent: uses the Laravel Eloquent ORM which is built on top of the Laravel query builder. This tests the incremental overhead of the Eloquent ORM models.

These tests measure overhead compared to a PHP-PDO implementation. Comparing these tests to the Laravel framework results also illustrates the overhead of the Laravel frontend components relative to the backend components.

Brion Finlay

Test URLs

JSON Encoding Test

http://localhost/json.php

Data-Store/Database Mapping Test

Raw: http://localhost/dbraw.php

ORM: http://localhost/dborm.php

Variable Query Test

Raw: http://localhost/dbraw.php?queries=5

ORM: http://localhost/dborm.php?queries=5

Eloquent ORM / Laravel Query Builder tests

Eloquent ORM

• db: http://localhost/eloquent/db-eloquent.php,
• query: http://localhost/eloquent/db-eloquent.php?queries=x
• update: http://localhost/eloquent/update-eloquent.php?queries=x
• fortune: http://localhost/eloquent/fortune-eloquent.php

Laravel Query Builder

• db: http://localhost/eloquent/db-laravel-query-builder.php