Awesome
PHP ORM Benchmark
ORMs to Benchmark
- Doctrine ORM v2.5.2
- Eloquent ORM (illuminate/database) v4.2.17
- FuelPHP Orm 1.7.3
- Phalcon ORM 2.0.8
- Propel ORM 2.0-dev
- Yii ActiveRecord 1.1.16
- Yii ActiveRecord 2.0.6
Results
These are my benchmarks, not yours. I encourage you to run on your (production equivalent) environments.
Benchmarking Environment
- CentOS 6.6 64bit (VM; VirtualBox with Vagrant Synced folder)
- PHP 5.5.30 (Remi RPM)
- Zend OPcache v7.0.4-dev
- MySQL 5.1
- Apache 2.2
- PHP 5.5.30 (Remi RPM)
(2015-12-10)
| orm | time (ms) | memory (KB) |
|---|---|---|
| doctrine | 109.81 | 1310.06 |
| propel2 | 51.32 | 1144.60 |
| eloquent | 34.46 | 673.80 |
| yii1 | 17.84 | 808.48 |
| fuel | 11.74 | 389.72 |
| yii2 | 9.09 | 835.82 |
| phalcon | 7.25 | 150.05 |
If you are interested in other resutls, see OTHER_RESULTS.md.
How to Benchmark
(1) Install this repository and install composer packages.
$ git clone https://github.com/kenjis/php-orm-benchmark.git
$ cd php-orm-benchmark
$ composer install
You may skip Phalcon by running composer install --ignore-platform-reqs, if you do not have it installed.
(2) Set public folder as your web document root. If you access http://localhost/, you can see the results graph.
(3) Configure fuel/app/config/development/db.php.
(4) Create database php_dev and import schema schema/php_dev.sql.
$ php oil r setup:mysql
(5) Generate config file for Propel.
$ php oil r setup:propel2
(6) Run benchmarks.
$ php oil r benchmark
See http://localhost/.
You can get markdown table for the results.
$ php oil r show:result_table
References
- Doctrine ORM
- Eloquent ORM
- FuelPHP 1.x Orm
- Phalcon ORM
- Propel 2
- Yii 1 ActiveRecord
- Yii 2 ActiveRecord