http://localhost:8080/trac/ticket/606 <p> This ticket is to track the issues left over from <a class="assigned ticket" href="http://localhost:8080/trac/ticket/590" title="defect: Drupal performance improvements (assigned)">#590</a> that need to be considered and tackled prior to migrating the site from D6 to D7 (or 8). </p> <p> Please feel free to add as needed, but sticky to the </p> <h2 id="CCleanup:Listoffeatureswedontreallyneed">C) Cleanup: List of features we don't really need</h2> <p> Ed to add his items to following list... Need rational and alternative approaches for each. </p> <ul><li><strong>C.1) Remove 'Geographic region' and related taxonomy and Hierarchical Select modules</strong> 1 hour, low reward, low risk -- never really been used and is effectively a duplicate of the location field. let's kill it! </li><li><strong>C.2) Kill Microsites and the Forums</strong> -- The handful of people using the CMS feature should be migrated to Open Atrium if they need such features. </li><li><strong>C.3) Remove forums</strong> -- We could migrate the forum to a simpler setup (not using forum module) that leverages normal commenting, or even Disqus or other services to offload comments and moderation. Also encourage user-submitted ocontent and promote that if it's good or gets interesting debate. </li></ul><h2 id="DKeydevelopmenttasks">D) Key development tasks</h2> <ul><li><strong>D.1) All inline PHP must be moved to modules and features</strong> -- This has great benefit for management, maintenance and developers. <tt>Eval()</tt>uated code is much slower than PHP in files, especially since it can't be accelerated by APC or Zend Opcode cache... We have a few blocks and many views that are loaded from the database and evaluated. Ideally the blocks would be moved to the 'Transition Extras' module, and the views would be pushed into features. This work is good to do for maintainability and D7 upgrades, too. See: <a class="ext-link" href="http://2bits.com/api/abuse-drupal-best-practices-your-own-peril-poor-performance.html"><span class="icon">​</span>http://2bits.com/api/abuse-drupal-best-practices-your-own-peril-poor-performance.html</a> and <a class="ext-link" href="http://2bits.com/articles/free-your-content-php-moving-php-code-out-blocks-views-and-nodes.html"><span class="icon">​</span>http://2bits.com/articles/free-your-content-php-moving-php-code-out-blocks-views-and-nodes.html</a> </li></ul><ul><li><strong>D.2) Build in ESI (Edge Side Includes) support from the outset, ensure Drupal renders only what it needs to </strong> -- BOA packages the <a class="ext-link" href="https://drupal.org/project/esi"><span class="icon">​</span>ESI (Edge Side Includes integration) module</a>, which makes NginX cache the whole page (as it does now), but also for user-logged in pages (which it does for 5 seconds since the page data changes). This means Drupal renders the ESI component (blocks, panels panes) that are have user-specific data in. Potential boost quickly, but will need time to tweak settings to get best from this across whole site. See <a class="ext-link" href="https://tech.transitionnetwork.org/trac/ticket/590#comment:4"><span class="icon">​</span>comments in 4 &amp; 5 below for discussion</a><del>, should be done after proposal F, above</del>. </li></ul><h2 id="EKeyeditorialtasks">E) Key editorial tasks</h2> <ul><li><strong>E.1) More Taxonomy cleanup</strong> -- try to merge terms with the same names, clear out spammy terms, general spit-and-polish. Ed plus team of busy interns to do this when the time is right. </li></ul><h2 id="Zoldstuffforreferencetasksfrom590renderedpointlessbymove">Z) old stuff for reference; tasks from <a class="assigned ticket" href="http://localhost:8080/trac/ticket/590" title="defect: Drupal performance improvements (assigned)">#590</a> rendered pointless by move</h2> <ul><li><strong>Z.1) Find Variable table writes and kill them</strong> -- seeing plenty of SELECT * FROM variable calls, which imply a cache clear due to a variable being set. In normal use variables shouldn't be set (admin screens tend to do this), so I'd like to try to see what module it causing this and patch/remove it. Will need to run <tt>grep -R "variable_set() * &gt; ~/static/variable_set-calls.txt" in the {{{sites/all</tt> directory to generate a list, then trawl though it to find candidates/bad modules practice. </li></ul> en-us /trac/chrome/site/TransitionNetwork-Logo-Web-Small.jpg http://localhost:8080/trac/ticket/606 Trac 0.12.5 jim Fri, 11 Oct 2013 12:00:13 GMT http://localhost:8080/trac/ticket/606#comment:1 http://localhost:8080/trac/ticket/606#comment:1 <ul> <li><strong>hours</strong> changed from <em>0.0</em> to <em>0.5</em> </li> <li><strong>totalhours</strong> changed from <em>0.0</em> to <em>0.5</em> </li> </ul> Ticket ed Tue, 22 Oct 2013 13:24:34 GMT http://localhost:8080/trac/ticket/606#comment:2 http://localhost:8080/trac/ticket/606#comment:2 <ol><li>October's maintenance time is all used up - so NO MORE work on this until November. </li><li>C.1) TN's strategy is heading towards regional model with CRM/membership style tools for regional hubs - it's not clear how 'regions' will be defined - so although this quartering of the UK hasn't worked in this version, we will be needing to define regions in some way in TN V3. Therefore - do we remove this earlier work and replace with something better and more CRM-y in 2014 or keep this earlier work? </li><li>C.2) CMS removal plan being formulated </li><li>C.3) Happy to remove forum technology but need to keep something onboard that lets normal users add posts of some form. Use of distributed technology tbd; depends on TN's strategy and apporach to using third party software, particularly distributed services (US-based) - ie what's the political line the web project is following... </li></ol> Ticket ed Thu, 24 Oct 2013 16:27:20 GMT http://localhost:8080/trac/ticket/606#comment:3 http://localhost:8080/trac/ticket/606#comment:3 <p> Also suggest </p> <ol><li>De-commission PSE - might help with load as well - been a high driver of traffic </li><li>De-commission Sharing Engine - also been quite heavy user </li></ol><p> Both are nice to have, but have not got traction to stop us closing them. Will be extra migration faff for little value, and probably need re-writing in D7 anyway. </p> Ticket ed Mon, 04 Nov 2013 11:18:23 GMT http://localhost:8080/trac/ticket/606#comment:4 http://localhost:8080/trac/ticket/606#comment:4 <ul> <li><strong>type</strong> changed from <em>task</em> to <em>enhancement</em> </li> <li><strong>milestone</strong> changed from <em>Drupal 7/8 upgrade</em> to <em>Maintenance</em> </li> </ul> Ticket