tarekdj / db-benchmark

http://forum.nette.org/cs/14592-lean-mapper-tenke-orm-nad-dibi?p=5#p106521
0 stars 0 forks source link

results #1

Open michield opened 10 years ago

michield commented 10 years ago

I've ran it quite a few times on my local machine now, with generally similar results:

NDB 2.2 | Time: 1.950 s | Memory: 14.0 MB | PHP: 5.5.3-1ubuntu2.3 | Nette: 2.2.x NotOrm | Time: 8.290 s | Memory: 7.3 MB | PHP: 5.5.3-1ubuntu2.3 PDO | Time: 0.089 s | Memory: 0.3 MB | PHP: 5.5.3-1ubuntu2.3 FluentPDO | Time: 0.721 s | Memory: 5.4 MB | PHP: 5.5.3-1ubuntu2.3 LeanMapper | Time: 1.668 s | Memory: 15.9 MB | PHP: 5.5.3-1ubuntu2.3 Doctrine2 | Time: 10.326 s | Memory: 27.4 MB | PHP: 5.5.3-1ubuntu2.3 | Doctrine: 2.4.2

tarekdj commented 10 years ago

FluentPDO seems to be better than NotOrm. But it still far from PDO.

michield commented 10 years ago

yes of these lot, apart from PDO, FluentPDO comes out best

tarekdj commented 10 years ago

added support for harp-orm lib. Bench results (Win7 OS):

NDB 2.2 | Time: 3.264 s | Memory: 8.5 MB | PHP: 5.4.15 | Nette: 2.2.x NotOrm | Time: 17.354 s | Memory: 7.1 MB | PHP: 5.4.15 PDO | Time: 0.299 s | Memory: 0.3 MB | PHP: 5.4.15 FluentPDO | Time: 1.341 s | Memory: 4.6 MB | PHP: 5.4.15 Harp-orm | Time: 1.719 s | Memory: 0.7 MB | PHP: 5.4.15 LeanMapper | Time: 3.326 s | Memory: 9.5 MB | PHP: 5.4.15 Doctrine2 | Time: 31.366 s | Memory: 19.4 MB | PHP: 5.4.15 | Doctrine: 2.4.2

tarekdj commented 10 years ago

Results after adding Pixie library:

NDB 2.2 | Time: 3.234 s | Memory: 8.5 MB | PHP: 5.4.15 | Nette: 2.2.x NotOrm | Time: 17.173 s | Memory: 7.1 MB | PHP: 5.4.15 PDO | Time: 0.302 s | Memory: 0.3 MB | PHP: 5.4.15 FluentPDO | Time: 1.282 s | Memory: 4.6 MB | PHP: 5.4.15 Harp-orm | Time: 1.646 s | Memory: 0.7 MB | PHP: 5.4.15 Pixie | Time: 1.596 s | Memory: 1.0 MB | PHP: 5.4.15 LeanMapper | Time: 3.304 s | Memory: 9.5 MB | PHP: 5.4.15 Doctrine2 | Time: 31.494 s | Memory: 19.4 MB | PHP: 5.4.15 | Doctrine: 2.4.2

michield commented 10 years ago

the Harp-orm is interesting. Very low memory use.

it will be good to compare a list of things they provide, once we have a shortlist.

tarekdj commented 10 years ago

@michield take a look at the Pixie library