<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 18, 2015 at 7:50 PM, Chirayu Chiripal <span dir="ltr"><<a href="mailto:chirayu.chiripal@gmail.com" target="_blank">chirayu.chiripal@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Mon, May 18, 2015 at 6:10 PM, Madhura Jayaratne <span dir="ltr"><<a href="mailto:madhura.cj@gmail.com" target="_blank">madhura.cj@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_quote"><div dir="ltr">Hi devs,<div><br></div><div>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.</div><div><br></div><div>The values are in milliseconds and contains profiling overhead as well. However, this should not be a problem to compare between two versions.</div><div><br></div><div><table style="border-collapse:collapse;width:310pt" border="0" cellpadding="0" cellspacing="0" width="412">
<colgroup><col style="width:116pt" width="155">
<col style="width:60pt" width="79">
<col style="width:63pt" width="83">
<col style="width:71pt" width="95">
</colgroup><tbody><tr style="height:14.5pt" height="19">
<td style="height:14.5pt;width:116pt" height="19" width="155">Page</td>
<td style="border-left-style:none;width:60pt" width="79"> 3.5 branch</td>
<td style="border-left-style:none;width:63pt" width="83"> 4.4 branch</td>
<td style="border-left-style:none;width:71pt" width="95"> 4.4 / 3.5</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Table browse</td>
<td style="border-top-style:none;border-left-style:none" align="right">5230.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">24548.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">4.69</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Table
structure</td>
<td style="border-top-style:none;border-left-style:none" align="right">2974.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">8060.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">2.71</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Table SQL</td>
<td style="border-top-style:none;border-left-style:none" align="right">760.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">1770.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">2.33</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Table
operations</td>
<td style="border-top-style:none;border-left-style:none" align="right">2564.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">7626.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">2.97</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Row edit</td>
<td style="border-top-style:none;border-left-style:none" align="right">2012</td>
<td style="border-top-style:none;border-left-style:none" align="right">10980.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">5.46</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Row insert</td>
<td style="border-top-style:none;border-left-style:none" align="right">2387.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">11553</td>
<td style="border-top-style:none;border-left-style:none" align="right">4.84</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Database
structure</td>
<td style="border-top-style:none;border-left-style:none" align="right">6280.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">5076.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">0.81</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Database SQL</td>
<td style="border-top-style:none;border-left-style:none" align="right">1511.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">1570</td>
<td style="border-top-style:none;border-left-style:none" align="right">1.04</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Database
operations</td>
<td style="border-top-style:none;border-left-style:none" align="right">3115.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">2750.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">0.88</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Server
databases</td>
<td style="border-top-style:none;border-left-style:none" align="right">2108</td>
<td style="border-top-style:none;border-left-style:none" align="right">3068.67</td>
<td style="border-top-style:none;border-left-style:none" align="right">1.46</td>
</tr>
<tr style="height:14.5pt" height="19">
<td style="height:14.5pt;border-top-style:none" height="19">Navigation
refresh</td>
<td style="border-top-style:none;border-left-style:none" align="right">626</td>
<td style="border-top-style:none;border-left-style:none" align="right">4092.33</td>
<td style="border-top-style:none;border-left-style:none" align="right">6.54</td>
</tr></tbody></table><br>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.</div><div><br></div><div>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.</div></div></div></div></blockquote><div><br></div></div></div><div>These are great stats. My concern would be for row edit/insert and table browse as those are most important operations for phpMyAdmin.<br> </div></div></div></div></blockquote></div>Yes, I will go through the profiling details to see which sub routines takes long time for these operations.<br clear="all"><div><br></div>-- <br><div class="gmail_signature">Thanks and Regards,<div><br></div><div>Madhura Jayaratne<br><div><br></div></div></div>
</div></div>