Changes between Version 10 and Version 11 of Ticket #369


Ignore:
Timestamp:
02/09/12 19:07:43 (5 years ago)
Author:
jim
Comment:

Updating and cleaning up for clarity...

DONE & REMOVED:

  1. Disable Drupal DB Logging, switching to SysLog? instead. -- Small but consistent boost, especially when under heavy load... We'd need a dev-friendly way of viewing the logs though. Very quick change.
  2. Lower session timeout to 1 day from whatever it is now -- PHP settings or settings.php tweak, quick-ish
  3. Enable more caching for panels/views -- this job is simple but long-ish... Many are done, some left to do.
  4. Add indexes to tables where needed.~

Marking 7, 8 (see #371), 9 (for Laura), 13 (see #357) as done or underway elsewhere. 11 is a bad idea.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #369

    • Property Add Hours to Ticket changed from 0.23 to 0.15
    • Property Total Hours changed from 2.53 to 2.68

  • Ticket #369 – Description

    v10 v11  
    11Per TTech discussion, some easy/quick things we can do to improve the site's performance... In rough order of ease technically and politically: 
    22 
    3 1. ~~Disable Drupal DB Logging, switching to SysLog instead. -- Small but consistent boost, especially when under heavy load... We'd need a dev-friendly way of viewing the logs though. Very quick change.~~ 
    432. Trawl SQL logs for slow queries, find out what's causing them and eradicate the cause -- tough job but potentially huge returns. 
    543. Add flood control/DoS blocking and other temporary blocks at the server level if an IP address or crawler bot is taking the piss. A job for Chris. 
    6 4. ~~Lower session timeout to 1 day from whatever it is now -- PHP settings or settings.php tweak, quick-ish~~ 
    7 5. ~~Enable more caching for panels/views -- this job is simple but long-ish... Many are done, some left to do.~~ 
    8 6. ~~Add indexes to tables where needed.~~~ 
    9 7. Do config/performance enhancement ideas from DB Tuner (was in {{{mysqltuner.log}}}, JK to run again around xmas) 
    10 8. Disable Piwik on LIVE and use Google Analytics instead OR move Piwik to another server. Chris is opposed to this but server resources are at a premium unfortunately -- See #371 
    11 9. Massively shrink site CSS -- Small performance increase for 'normal' users, BIG gains for older computers and mobile devices - As Laura points out, better than lots of images, but it still needs to re-use CSS rules/selectors where possible and throw out legacy code. 
     57. ~~Do config/performance enhancement ideas from DB Tuner (was in {{{mysqltuner.log}}}, JK to run again around xmas)~~ 
     68. ~~Disable Piwik on LIVE and use Google Analytics instead OR move Piwik to another server. Chris is opposed to this but server resources are at a premium unfortunately -- See #371~~ 
     79. ~~Massively shrink site CSS -- Small performance increase for 'normal' users, BIG gains for older computers and mobile devices - As Laura points out, better than lots of images, but it still needs to re-use CSS rules/selectors where possible and throw out legacy code.~~ 
    12810. Force HTTP only for non-logged in users (explained above) -- BIG boost, quick settings change, though might need Chris to alter htaccess/varnish setup. 
    13 11. Enable Throttle module to auto-disable modules during heavy loads -- Throttle gets a bad press and can cause issues, 
     911. ~~Enable Throttle module to auto-disable modules during heavy loads -- Throttle gets a bad press and can cause issues.~~ 
    141012. Go on a module cull -- This is hard and slow, and will result in a loss of functionality. But some modules could be dropped if there's a will. 
    15 13. Switch to NGINX -- Chris thinks this is a lot of work, see #357 
     1113. ~~Switch to NGINX -- Chris thinks this is a lot of work, see #357~~