RocketTheme - TOPIC: Very slow 1.6 page loads

Welcome Guest! Login

0 items Join Now

- DirtySnipe
- Hero Rocketeer
- Posts: 424
- Thanks: 0
- ICT Manager
Very slow 1.6 page loads

Posted 14 years 4 weeks ago
- I'm currently running 1.6.1
  
  My page loads a crippling me and are unacceptable..
  
  Here is a complete debug
  
  Profile Information
  Application 0.018 seconds (+0.018); 0.28 MB (+0.28) - afterLoad
  Application 0.806 seconds (+0.788); 3.59 MB (+3.31) - afterInitialise
  Application 0.999 seconds (+0.192); 4.11 MB (+0.52) - afterRoute
  Application 1.614 seconds (+0.615); 6.08 MB (+1.97) - afterDispatch
  Application 4.746 seconds (+3.132); 10.83 MB (+4.74) - afterRender
  Memory Usage
  10.85 MB (11,373,336 Bytes)
  6 Queries Logged
  
  1. SELECT `data`
  FROM `jos_session`
  WHERE `session_id` = '2e27a73bc9cd9ab5f9f07da4c23f6480'
  2. DELETE
  FROM `jos_session`
  WHERE `time` < 1302681797
  3. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  4. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  5. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  6. UPDATE `jos_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1302682145;s:18:\"session.timer.last\";i:1302682552;s:17:\"session.timer.now\";i:1302682697;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"9bb7db3a929d09889842715dab952905\";}', `time` = 1302682701
  WHERE `session_id` = '2e27a73bc9cd9ab5f9f07da4c23f6480'
  
  4 Query Types Logged, Sorted by Occurrences.
  SELECT Tables:
  
  1. 3 × SELECT template FROM jos_template_styles
  2. 1 × SELECT `data` FROM `jos_session`
  
  OTHER Tables:
  
  1. 1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1302682145;s:18:\"session.timer.last\";i:1302682552;s:17:\"session.timer.now\";i:1302682697;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"9bb7db3a929d09889842715dab952905\";}', `time` = 1302682701
  2. 1 × DELETE FROM `jos_session`
- Last Edit: 14 years 4 weeks ago by DirtySnipe.
#643971
- DirtySnipe
- Hero Rocketeer
- Posts: 424
- Thanks: 0
- ICT Manager
Re: Very slow 1.6 page loads

Posted 14 years 4 weeks ago
- This is running on an internal 1GB network.
  Xampp dev server
  windows 2003 r2
  3GB RAM
  PHP 5.2.5
  MYSQL 5.0.51
  
  I have not gone down the route of server optimization for joomla as im not 100% sure on a good php / mysql setup.
  
  Any ideas would be greatly appreciated.
#644215
- DirtySnipe
- Hero Rocketeer
- Posts: 424
- Thanks: 0
- ICT Manager
Re: Very slow 1.6 page loads

Posted 14 years 4 weeks ago
- I have just setup a WAMP server on my W7 64 system as another test.
  
  Changed the mysql config to large setup which uses alot more system resources for better performance.
  PHP 5.3.5
  MYSQL 5.5.8
  
  I have xfered the same files and db and here is debug.
  
  Profile Information
  Application 0.002 seconds (+0.002); 0.61 MB (+0.61) - afterLoad
  Application 0.075 seconds (+0.073); 4.76 MB (+4.15) - afterInitialise
  Application 0.090 seconds (+0.015); 5.44 MB (+0.68) - afterRoute
  Application 0.133 seconds (+0.043); 8.01 MB (+2.56) - afterDispatch
  Application 0.498 seconds (+0.364); 13.79 MB (+5.79) - afterRender
  Memory Usage
  13.79 MB (14,463,160 Bytes)
  5 Queries Logged
  
  1. SELECT `data`
  FROM `jos_session`
  WHERE `session_id` = 'gf41o7uk7lrttjbodtrid5v4f4'
  2. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  3. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  4. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  5. UPDATE `jos_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1302682078;s:18:\"session.timer.last\";i:1302682584;s:17:\"session.timer.now\";i:1302682596;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"60f60ec5fadd48d7d05e7371013576c7\";}', `time` = 1302682596
  WHERE `session_id` = 'gf41o7uk7lrttjbodtrid5v4f4'
  
  3 Query Types Logged, Sorted by Occurrences.
  SELECT Tables:
  
  1. 3 × SELECT template FROM jos_template_styles
  2. 1 × SELECT `data` FROM `jos_session`
  
  OTHER Tables:
  
  1. 1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1302682078;s:18:\"session.timer.last\";i:1302682584;s:17:\"session.timer.now\";i:1302682596;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"60f60ec5fadd48d7d05e7371013576c7\";}', `time` = 1302682596
#644220
- DirtySnipe
- Hero Rocketeer
- Posts: 424
- Thanks: 0
- ICT Manager
Re: Very slow 1.6 page loads

Posted 14 years 4 weeks ago
- Tried on another wamp uniform server 7.0.1 and im getting these results.
  
  Profile Information
  Application 0.001 seconds (+0.001); 0.36 MB (+0.36) - afterLoad
  Application 0.055 seconds (+0.054); 0.97 MB (+0.61) - afterInitialise
  Application 0.068 seconds (+0.012); 1.10 MB (+0.12) - afterRoute
  Application 0.098 seconds (+0.030); 1.41 MB (+0.31) - afterDispatch
  Application 0.381 seconds (+0.283); 3.08 MB (+1.68) - afterRender
  Memory Usage
  3.1 MB (3,248,736 Bytes)
  5 Queries Logged
  
  1. SELECT `data`
  FROM `jos_session`
  WHERE `session_id` = 'i0rvo1ua3905jgkvgcric4oco0'
  2. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  3. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  4. SELECT template
  FROM jos_template_styles
  WHERE home = 1
  AND client_id = 0
  5. UPDATE `jos_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1302693376;s:18:\"session.timer.last\";i:1302693376;s:17:\"session.timer.now\";i:1302694142;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ebf02ad891f6bd47b251270a6a16824a\";}', `time` = 1302694143
  WHERE `session_id` = 'i0rvo1ua3905jgkvgcric4oco0'
  
  3 Query Types Logged, Sorted by Occurrences.
  SELECT Tables:
  
  1. 3 × SELECT template FROM jos_template_styles
  2. 1 × SELECT `data` FROM `jos_session`
  
  OTHER Tables:
  
  1. 1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1302693376;s:18:\"session.timer.last\";i:1302693376;s:17:\"session.timer.now\";i:1302694142;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ebf02ad891f6bd47b251270a6a16824a\";}', `time` = 1302694143
  
  This is looking more and more like a server related issue.
  Currently thinking of using the uniform server.
#644270

Time to create page: 0.185 seconds

Very slow 1.6 page loads

Very slow 1.6 page loads

Re: Very slow 1.6 page loads

Re: Very slow 1.6 page loads

Re: Very slow 1.6 page loads