[Phpmyadmin-devel] Profiling for performance analysis

Madhura Jayaratne madhura.cj at gmail.com
Mon May 18 14:40:50 CEST 2015


Hi devs,

As discussed during the last team meeting, I did some profiling to evaluate
the performance of 4.4 series against 3.5 series. I used xdebug for
profiling and for each of the pages evaluated, I averaged among three
reading to overcome any errors.

The values are in milliseconds and contains profiling overhead as well.
However, this should not be a problem to compare between two versions.

   Page     3.5 branch       4.4 branch              4.4 / 3.5  Table browse
5230.67 24548.67 4.69  Table structure 2974.67 8060.67 2.71  Table SQL
760.33 1770.33 2.33  Table operations 2564.33 7626.33 2.97  Row edit 2012
10980.67 5.46  Row insert 2387.67 11553 4.84  Database structure 6280.33
5076.33 0.81  Database SQL 1511.67 1570 1.04  Database operations 3115.33
2750.67 0.88  Server databases 2108 3068.67 1.46  Navigation refresh 626
4092.33 6.54
While I got mixed results where for certain pages 3.5 was faster and for
others 4.4 was faster, for most of the pages 3.5 was much faster.

I am attaching the results in csv format as well as output files from
profiling. With KCacheGrind or WinCacheGrind you should be able to further
analyze the profiling results.

-- 
Thanks and Regards,

Madhura Jayaratne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20150518/5e36c55a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: results.csv
Type: text/csv
Size: 430 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20150518/5e36c55a/attachment.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Profile.7z
Type: application/octet-stream
Size: 5358507 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20150518/5e36c55a/attachment.obj>


More information about the Developers mailing list