On Mon, Jul 27, 2015 at 7:10 PM, Marc Delisle marc@infomarc.info wrote:

Hi Nisard, you wrote in your blog "I carried out further performance analysis for page-related settings by profiling performance with xdebug. The function call to PMA_userprefsPageInit() takes most of the time. I couldn't see any way to reduce this time, though."

In PMA_userprefsPageInit() there are five functions called; did you verify which of those is taking most of the time?

-- Marc Delisle | phpMyAdmin

---

Developers mailing list Developers@phpmyadmin.net http://lists.phpmyadmin.net/mailman/listinfo/developers

Hi Marc,

Here is the slightly more detailed analysis result,

PMA_PageSetting->__construct() takes around 35% of the page load for my test.

PMA_PageSetting->__construct() 63.73% -> PMA_userprefsPageInit() 22.70% -> PMA_PageSettings->_getPageSettingsDisplay() ...

PMA_PageSettings->_getPageSettingsDisplay() 98.81% -> FormDisplay->getDisplay() ...

PMA_userprefsPageInit() 92.75% -> ConfigFile->updateWithGlobalConfig() ...

ConfigFile->updateWithGlobalConfig() 58.29% -> ConfigFile->set (492 times total) 26.48% -> array_walk performing ConfigFile->_flattenArray() (508 times total)

Percentages are relative to the parent call.

I still have a slight hope that we can reduce this numbers as we don't need all the config options processed every time, but I am not so sure about it.