[Phpmyadmin-devel] Profiling for performance analysis

[Isaac Bennetch]

On 5/18/15 8:40 AM, Madhura Jayaratne wrote:
> 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 for the work, this is quite interesting.

> -- 
> Thanks and Regards,
> 
> Madhura Jayaratne
> 
> 
> 
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud 
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> 
> 
> 
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>