Thread

Hi -

We are running into an issue that we’ve been troubleshooting for a few days now, and have not come up with an answer.

We have the latest version of EE installed on IIS6. HTML pages served by II6 are loading very quickly, but when we have a very basic HTML page loaded by EE, the page loads but there is always excessive waiting time as shown in Firebug and Chrome Developer tools.  I don’t know what it is waiting for given that we aren’t calling any specific EE templates or any EE functionality.  The only change is that the template is being called by index.php (EE).

The database is on the local server (MySQL).

Any suggestions on how to diagnose this?

Adrian

FWIW, here is the contents of my database.php file:

$db['expressionengine']['hostname'] = 'localhost';
$db['expressionengine']['username'] = 'xxx';
$db['expressionengine']['password'] = 'xxx';
$db['expressionengine']['database'] = 'xxx';
$db['expressionengine']['dbdriver'] = 'mysql';
$db['expressionengine']['pconnect'] = FALSE;
$db['expressionengine']['dbprefix'] = 'exp_';
$db['expressionengine']['swap_pre'] = 'exp_';
$db['expressionengine']['db_debug'] = FALSE;
$db['expressionengine']['cache_on'] = TRUE;
$db['expressionengine']['autoinit'] = FALSE;
$db['expressionengine']['char_set'] = 'utf8';
$db['expressionengine']['dbcollat'] = 'utf8_general_ci';
$db['expressionengine']['cachedir'] = 'F:\\wwwroot\\xxx\\system\\expressionengine\\cache\\db_cache\\';

I just corrected the cachedir path and changed the cache_on variable to true; it does not appear that has made a significant difference (if at all).

I’d try turning on the Output Profiler to see if it can provide any clues.

Thanks for your response.

For some reason I am now unable to modify that particular setting, or any settings on the “Output and Debugging Preferences” panel.  Do you know what file is being used or modified by this page?

The only EE file I made direct modifications to is EE_Output.php to comment out the following lines:

$this->set_header(“Expires: Mon, 26 Jul 1997 05:00:00 GMT”);
$this->set_header(“Pragma: no-cache”);

Not sure if this is related, but thought I would mention it.

Can you make and save any settings in the CP?

Yes.  For example, I can change settings in the Database Settings section.

While I am still puzzled why I am unable to modify settings on this page, is there a way to set this flag outside of the interface?

There is a config file some “hidden” config settings but I don’t see those specific ones in there:
http://ellislab.com/expressionengine/user-guide/general/hidden_configuration_variables.html

I’m out of ideas here…hope the tech support guys can step in.

Hi WCGDigital,

Thanks for posting on the Forums!

Can you share a safe copy of your config.php file? We’ll be able to pick out anything that looks out of place.

Cheers,

The “Output Profiler” problem has been resolved; I changed the CACHING setting in the database.php file back to NO, and we’re able to change debugging settings as we would normally.

Hi Adrian,

So as I take it, you’re now able to turn on the Output Profiler and Template Debugger, right? But you still have slow loading issues?

Could you share with us the results of the Output Profiler and Template Debugger? Just copy them here or take a screenshot.

Wondering if there are any thoughts to this or was there any answers.  I notice the same thing.  Regular HTML pages are served under 100ms even under 50ms, but that same file put into an EE template can go to 400-700ms.  Always a lot of waiting time in firebug.  Is there something I can look for in the output profiler?

Well i noticed one thing everytime it appeared that the site was hanging/waiting, it was always the following query

UPDATE `exp_sessions` SET `session_id` = ‘4e31e7209c0cb35fa25b9a5d31a6838cbdc04d54’, `member_id` = 1, `admin_sess` = 1, `ip_address` = ‘xxx.xx.xx.xx’, `user_agent` = ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4’, `last_activity` = 1352526037 WHERE session_id =‘4e31e7209c0cb35fa25b9a5d31a6838cbdc04d54’

Sometimes the page is fast and its .05, then other times i have seen it go from 4 to 12 seconds.  Can anything be done or looked at for the database to make sure its updating this table as quickly as possible?

Hey jeffmace,

Can you tell me which hosting service you use?

Thank you,

I have a dedicated server and dedicated mysql server.  I host with Enterhost http://www.enterhost.com