Changes between Version 46 and Version 50 of Ticket #590


Ignore:
Timestamp:
11/18/13 10:48:28 (3 years ago)
Author:
jim
Comment:

Views content cache work now done.. Might have some side effects, Ed please shout if anything doesn't appear to be updating or is wonky in a view.

All the key stuff on this ticket is done bar a few low priority/impact ones... Downgrading.

Ed to close if he's happy with Drupal-level performance.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #590

    • Property Total Hours changed from 16.15 to 16.95
    • Property Add Hours to Ticket changed from 0.05 to 0.5
    • Property Priority changed from critical to minor

  • Ticket #590 – Description

    v46 v50  
    77= Summary of actions and status = 
    88== TODO == 
    9  
    10 '''D) Review Views caching''' 1 hour, low risk, high reward -- Utilise Views Content Cache ~~this was done a while back but I think -- done (task 12) in comment 21.~~ 
    11  
    12  
    139'''O) Stop making so many URL aliases for non-relevant pages, clean up url_alias table''' -- 1/4-1/2 hour, medium reward, only risk is that some already broken links might break... Per chat with Ed, only these will be removed (plus releated tweaks to Pathauto settings): 
    1410* 3,579 entries where src = node/%/feed 
    1511* 1,856 entries where src = user/%/contact 
    1612* = 5,435 or ~11% of entries in url_alias 
    17  
    1813 
    1914'''L) Review slow query log, explain queries, tweak as necessary/flag poorly behaving modules.''' 2-4 hours, high reward, low risk... Keep looking at the slow query log and adjust Drupal or find patches as necessary. ALSO related [http://2bits.com/articles/reduce-your-servers-resource-usage-moving-mysql-temporary-directory-ram-disk.html Reduce your server's resource usage by moving MySQL temporary directory to tmpfs]... Have opened ticket for this: #591 for Chris. 
    … …  
    2318 
    2419'''B) Try a Taxonomy Cleanup''':  ~~3 hours, Medium risk, medium reward -- style module to try to merge terms with the same names and clean up the link tables back to nodes. Further, we can remove any taxonomies or relations to certain CTs that don't really add value.~~ 
     20 
     21'''D) Review Views caching''' ~~1 hour, low risk, high reward -- Utilise Views Content Cache this was done a while back but I think -- done (task 12) in comment 21.~~ 
    2522 
    2623'''F) Force blocks caches to cached appropriately (and be rendered/included only as needed)''' ~~1-2 hours, medium reward, low risk -- BOA packages the [https://drupal.org/project/blockcache_alter Block Cache Alter], which makes sure Drupal only renders blocks when needed. Potential small but nice boost quickly in whole site. -- per comment 22, block caching is disabled by other modules so this will have to go on hold for now.~~