Repository files navigation

This repository contains benchmarks for some of the most popular PHP DataMapper's, used as a reference for performanceoptimizations in my personal projectcompositephp/db.

The projects benchmarked include:

• Doctrine
• Laravel Eloquent
• Cycle ORM
• Composite DB
• PHPFUI ORM

• The benchmark executes 10 000 CRUD (Create, Read, Update, Delete) operations to assess the performance.
• The benchmark tests focus exclusively on the 'DataMapper' component of each project, employing simple queries that donot involve relationships, foreign keys, or joins.

Operations include:

1. Creating a new record in the database.
2. Reading the record by primary key.
3. Updating one field for the found record.
4. Deleting the record.

• MySQL 8.0
• Table used for the benchmark:

CREATETABLEIF NOT EXISTS Users(`id`INTEGERNOT NULLPRIMARY KEY AUTO_INCREMENT,`name`VARCHAR(255)NOT NULL,`age`INTEGERNOT NULL,`microtime` FLOATNOT NULL,`created_at`TIMESTAMP DEFAULTCURRENT_TIMESTAMPNOT NULL);

• PHP 8.1+
• Docker
• Composer
• PDO_MySQL extension

1. Clone or download this repository
2. Runcomposer update
3. Executedocker-compose up
4. Run benchmarks for each DataMapper separately:
   • php src/test-laravel.php
   • php src/test-cycle.php
   • php src/test-doctrine.php
   • php src/test-composite.php
   • php src/test-PHPFUI.php

This is a synthetic benchmark focused on speed and memory consumption and does not compare the feature list of the projects.Feel free to note any problems, inaccuracies, or shortcomings in using these projects and make a pull request to fix them.