Profiling of persistence framework / CR
We need to have an intensive profiling session for figuring out where the weaknesses currently are regarding speed of persistence.
#1 Updated by Karsten Dambekalns about 10 years ago
I worked on this using XHProf (http://mirror.facebook.net/facebook/xhprof/) as Xdebug is awefully slow (albeit it's traces provide more detail - which we currently don't really need). I used the blog with 100 posts in it and the attached index.php for profiling.
Make sure to turn off SpeedStep (or similar) technologies and only use CPU time for comparison, wall time may differ massively between subsequent runs. On a Mac it seems only CoolBook (http://www.coolbook.se/CoolBook.html) is available for this.Results:
- SQLite is awefully slow compared to MySQL
- Object creation takes a lot of time, see #3740 for a followup task
I could bring the CPU time down by about a quarter when replacing a few object creation calls within the persistence layer with
new calls, so speeding up object creation seems to be advisable.