[eluser]m4rw3r[/eluser]
I've made a very simple performance comparison between Doctrine and RDM:
Result: RDM is about equal in performance when it comes to extracting a whole object graph or multiple objects, but it is very fast when fetching a single row.
Objects:
Code:
Country:
id
name
Region:
id
name
country_id
City
id
name
country_id
region_id
Object Graph:
Fetch the country Sweden, all its regions and their corresponding cities (which means 239 rows with all joined through LEFT JOINs).
10 repetitions, to get it below 30 seconds all times (goes for both RDM and Doctrine).
Single object:
Fetching a single row from the country table with the id 23 (and no caching was allowed).
1000 repetitions.
Multiple objects:
Fetching all related regions to the country with the id 23.
1000 repetitions.
Results
In seconds
RDM:
Object Graph: 16.068867921829
Single Object: 1.3140540122986
Multiple Objects: 2.9177198410034
Doctrine:
Object Graph: 16.564059019089
Single Object: 17.68523812294
Multiple Objects: 2.5408611297607
CI's AR:
Object Graph: 0.16973185539246 (Not really comparable, because it fetches a single row for each country-region-city combination)
Single Object: 2.1052830219269
Multiple Objects: 2.3604340553284
(Have no idea what happened in the Single Object fetch for Doctrine, I just used Doctrine_Core->getTable('Country')->find(23)
NOTE: No caching has been used, not by RDM nor by Doctrine (unless doctrine does some caching without the user's knowledge).
PS. I have not done any specific performance optimizations for RDM during any of the stages in development, so this speed is currently inherent to its design
But I think I will do some soon, fetching large object graphs was hard work and I had to go down to below 10 iterations to get it under 30 all times (for both Doctrine and RDM).
